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.
