A
AG
Access 97 with split FE/BE
I have a query based on 5 tables with one inner join and 3 outer joins in
FE.
Two tables have about 125,000 records each, one has about 17,000 records and
two have about 80 records.
The query has parameters derived from form textboxes and is used for a
form's recordsource.
Performance has been excellent until I tried to change the query.
With the original query, parameters that would return results in 1-2
seconds, not take 8+ seconds.
Initially, I thought that I inadvertently changed something that I did not
intend to, so I imported the original query from a backup copy of the FE. It
ran fine.
Opened the query in design view, changed nothing and did File > SaveAs ...
Performance of the new query dropped like a rock -- NOTHING WAS CHANGED!
Tried several times and got same results.
I have decompiled, compiled, repaired and compacted.
Can anyone offer an explanation/solution?
I have a query based on 5 tables with one inner join and 3 outer joins in
FE.
Two tables have about 125,000 records each, one has about 17,000 records and
two have about 80 records.
The query has parameters derived from form textboxes and is used for a
form's recordsource.
Performance has been excellent until I tried to change the query.
With the original query, parameters that would return results in 1-2
seconds, not take 8+ seconds.
Initially, I thought that I inadvertently changed something that I did not
intend to, so I imported the original query from a backup copy of the FE. It
ran fine.
Opened the query in design view, changed nothing and did File > SaveAs ...
Performance of the new query dropped like a rock -- NOTHING WAS CHANGED!
Tried several times and got same results.
I have decompiled, compiled, repaired and compacted.
Can anyone offer an explanation/solution?