See answers in the message below.
Marc.
-Message d'origine-
De : Ben Clewett [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 4 juin 2004 10:37
À : [EMAIL PROTECTED]
Objet : Three quick questions about using MySQL
Three quick questions, I hope you can help me.
Using InnoDB on ve
Three quick questions, I hope you can help me.
Using InnoDB on version 4.0.18
Firstly.
It's possible to get information on a table. Which includes the number
of rows. This returns instantly.
However, if I do a SELECT COUNT(*) on the same table, this can take a
number of minutes to return. (about