Slow search

[jda]

Hi Ruslan,

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?

Jon