Question about search speed

[jda]

Good point! I didn't when I designed this search (years ago), but I do now. I'll try that.

Thanks.

Jon

P.S. FWIW, in the original search I tried using RecID instead of my own id field

      SELECT * FROM mytable WHERE id > (select max(id) - 20 from mutable)

This improved the speed, but only about twofold: 20 seconds to 10 seconds. Still slow.


> Do you have a creation date time for your records ?
> 
> select * from myTable order by creation_dt DESC limit 20
> 
> hth
> 
> Bart
> 
> 
> On 28 Jan 2013, at 14:33, jda <jda at his.com> wrote:
> 
>> 
>> I have a built-in search that finds the last 20 records entered. Each record has a unique sequential number (1..N) in the field "id", and this is the query:
>> 
>> 
>>    SELECT * FROM mytable WHERE id > (select max(id) - 20 from mytable)
>> 
>> 
>> It works, but is very slow. With a database of ~7000 records it takes ~20 seconds.
>> 
>> Is there a way to optimize this (using V4.9.1, Mac OS X).
>> 
>> Thanks,
>> 
>> Jon
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina