Slow search

[Ruslan Zasukhin]

On 8/18/09 3:20 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> Using V4RB 3.x this search (id is a long) used to be virtually instantaneous:
> 
>      SELECT * FROM theTable WHERE id > (select max(id) - 20 from theTable)
> 
> 
> With V4RB 4 it's taking about 15 seconds (there are about 4500 records).
> 
> Do you know the reason for this? Or should I report it on Mantis?

Yes please report with DB

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]