On Wednesday 21 March 2007 16:02, Elazar Leibovich wrote: > The whole table. SELECT COUNT(*) FROM tbl WHERE id>1; > Thanks for the speedy reply.
Without knowing how mysql works, i can tell you are running this query all wrong. You need to use SELECT COUNT(*) FROM tbl; without the WHERE clause in order for it to feel comfortable to use its statistics instead of actually searching the table. -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
