Would this work on my machine?

A lot of times, I end up answering to a certain sect of questions.

1) I don’t have this, would the software work for me?
2) Would it work without the libraries?
3) Would it work on a Windows 2003 server with S123456789 service pack with PHP 5.12345 version and Mysql 5.98765 version?
4) I host with Godaddy and they say that they can’t provide that option. Would it work without the option?
5) I host with Comemommy and they don’t want to install it, would it work without installing?

and just every other question they can come up with except the right question!! and what do I usually say? Should I say, “ Give me some time, let me replicate the exact condition here and then I would tell you whether it works or not!! “.. No, as a good worker, I always end up saying.. “Yeah!! This would!!”, “No, This wouldn’t. But if I can buy some of your time, it definitely would!”.

Wouldn’t it be better if I tell just tell, “Well this mostly depends on your machine. Testing it is usually the quickest way to find out.” So, do test it out while having your coffee and lemme know if it worked or not!!

Wouldn’t this be easy? These people are a real lot clever!!


Most common HTTP status codes

200 (OK): The resource was found and all is well.

304 (NOT MODIFIED): The resource has not been modified since the last request. This is used most often for browser cache mechanisms.

401 (UNAUTHORIZED) : The clien is not authorized to handle the resource. Often, this will cause the browser to ask for a username and password to log in to the server.

403 (FORBIDDEN): The client failed to gain authorization. This typically happens if you fail to log in with the correct username and password after a 401.

404 (NOT FOUND): The resource does not exist at the given location.

Optimizing SQL for better performance

One of the basic nightmares of a web developer is optimizing queries. Every now and then, I keep seeing articles which advise lesser queries per web page, normalised tables, indexes on the most queried columns and a diligent logic.

Ofcourse, this is what is needed. But at the same time, not everyone is exposed to better optimization techniques. If you are one of those, who have written a perfect SQL but still wondering why it takes that longer for it to get executed, read on.

Continue reading “Optimizing SQL for better performance”