Posted by Toby A Inkster on 03/13/07 15:16

Vincent Delporte wrote:

> Some kind of social site

These sorts of things usually develop into having some pretty big database
tables.

Do you have any "big" tables (say, 2000 rows or more)? Which columns do
you routinely query those big tables by, or join them on? Are those columns
indexed?

Are you using inappropriate data types? (e.g. Storing dates in a varchar
field, which although possible, is very inefficient for queries.)

Do you unnecessarily use "SELECT * FROM ..." when "SELECT x, y FROM ..."
would suffice?

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!

[Back to original message]