Question about search speed

[Bart Pietercil]

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