>>I have a parameterized view that is used in a couple of different forms. The first time that the view is queried after a form is opened, it is extremely slow (8-10 seconds). After that, when changing the parameters and REQUERYing, the view returns results instantaneously. The view is only slow the first time. All the fields that the view filters and joins on are indexed. Does anybody know what causes this behavior?
>Erik,
>
>Is it possible that you are setting deleted off in one of the form's events? Do you ahve an index on deleted() for the tables involved with the view?
>
>If you set deleted off in a fomr method then t is on the first time the view gets populated and then it is off. This will affect the speed of teh query if there is no index on deleted.
In addition, If Jim's assessment is not the cause, the speed of the query is also affect by whether the tables involved in the query is already open or not. If the query is slow only the first time you run it, it might be that VFP is taking time to open the table(s) involved in the query. If the query involves many tables, this could cause delays. I try to keep most all tables open when running the application.