Saved Query too slow

[xxpeta]

Hi All,

I have some trouble with functionality Saved Query in my custom application. When I use QBE for filtering records, it runs quickly. But when I use the functionality Saved Query to save the same query as I made via QBE, it tooks few minutes to get result. It looks like this functionality is not selecting but hiding records.

The view is quite complicated, because there are 2 standard tables and 1 fake table (SQL view with union from 2 tables).

Do you have any idea to make it faster?

Thanks for your replies.

Petr

 

[David Robertson]

I would start by turning on debugging and checking what the differences in the SQL being generated are.

I haven't made a lot of use of the save query functionality, but I had assumed as you have, that it was simply saving the QBE settings.