Re: Long select time in big tables

[Karolis]

I also thought you might want to see EXPLAIN of this query:

mysql> explain SELECT ImageID, Width1, Height1, FileName
-> FROM IMAGES
-> WHERE ImageID IN(102116,144855,188030,243406,247262,297552,309613,310700,426370,446944);
+----+-------------+--------+-------+---------------+---------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+---------+---------+------+------+-------------+
| 1 | SIMPLE | IMAGES | range | PRIMARY | PRIMARY | 4 | NULL | 10 | Using where |
+----+-------------+--------+-------+---------------+---------+---------+------+------+-------------+

Karolis