Of course I do. I didn't really want to count all the table, I wanted to get a raw benchmark of how quickly will I be able to perform more complex queries on the database. That's why I didn't want it to use a prestored value (MySQL does that with MyISAM tables only BTW) to give me my wish, but to actually process the data.
On 3/21/07, Tzahi Fadida <[EMAIL PROTECTED]> wrote:
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]
