RE: Three quick questions about using MySQL

2004-06-04 Thread Mechain Marc
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 about using MySQL

2004-06-04 Thread Ben Clewett
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