Re: slow selects

[Danie Van der Walt]

After the change in the index....
It seems to have lost the filesort....

I will test with some more records and get back to you but for now here is the explain info....
+---------+------+----------------------------------+---------------------+---------+-------------+------+-------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+---------+------+----------------------------------+---------------------+---------+-------------+------+-------------+
| tSMSOUT | ref | index_status_sentby,index_status | index_status_sentby | 51 | const,const | 1 | Using where |
+---------+------+----------------------------------+---------------------+---------+-------------+------+-------------+
explain select id,service_type,source_addr,destination_addr,message_payload,user_message_reference,esm_class from tSMSOUT where status='0' and sentby="196.11.240.100ISOL_001ConnectPRS" order by id asc limit 1


Thanks a mill....



Edited 1 time(s). Last edit at 09/02/2006 12:52PM by Danie Van der Walt.