October 6, 2008

MySQL Select Optimization line

Weather used in php or any other scripting language… sometimes we have the need to query a database in order to fetch or manipulate certain data. One of the most common request, widely written and used is SELECT * FROM MyTable WHERE ID='ValueX' and NAME='ValueY'; now, ID and NAME are just columns… so nothing special However.. how could someone optimize that line of code? Fact is, lots of coders out there, do not realize how unoptimize this line could be and the different problems it could generate. ... Read more