Heikki,
HT> can you print the EXPLAIN SELECT ... for the count(*) and the other query?
mysql> explain select count(*) from mybuffer where bourse='NAS';
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra
| |
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
| mybuffer | ref | id_bourse | id_bourse | 3 | const | 730 | where used;
|Using index |
+----------+------+---------------+-----------+---------+-------+------+-------------------------+
1 row in set (0.00 sec)
mysql> explain select * from mybuffer where bourse='NAS';
+----------+------+---------------+-----------+---------+-------+------+------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+----------+------+---------------+-----------+---------+-------+------+------------+
| mybuffer | ref | id_bourse | id_bourse | 3 | const | 730 | where used |
+----------+------+---------------+-----------+---------+-------+------+------------+
1 row in set (0.00 sec)
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php