Saved Query too slow

xxpeta

Active Member
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

Reputable Poster
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.
 
Top