Reinier,
Thursday, August 15, 2002, 1:13:32 PM, you wrote:
RvH> I have a mysql database latest version from the freebsd ports running on a
RvH> 350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server.
RvH> I have a database with 5.5 million record in say 1 table. We use this
RvH>
Reinier,
> It seems that when i do a select and the result is minimal it uses the
> index(fast about 3 sec), but when the result is much more it is not using
> the index. this results in a lot of disk io and taking to much time.
It is correct, because (http://www.mysql.com/doc/en/MySQL_indexes.h
