cost of querys
Posted: Wed Nov 09, 2005 11:52 am
I have a MySQL table with about 20 columns. If I select one row from the name with * (ex: "SELECT * FROM table WHERE id='1' LIMIT 0, 1"), how much more costly is this than a slection where I specifically specify which columns I want (ex: "SELECT name, email, phone, address FROM table WHERE id='1' LIMIT 0,1")?
Is there website that explains this kind of stuff for other types of queries in MySQL?
Is there any code that someone has written where if i put it on the btotom of my page, it would print out how many trips to the database it made? I could just count it up, but with certain pages having different includes it owuld be easier if code existed.
Is there website that explains this kind of stuff for other types of queries in MySQL?
Is there any code that someone has written where if i put it on the btotom of my page, it would print out how many trips to the database it made? I could just count it up, but with certain pages having different includes it owuld be easier if code existed.