B
Bart
Hello,
I have a number of queries in an application that all reference a single key
field in a table to set the selection criteria for each query. I can either
set the criteria separately in each query or include another query that sets
the criteria within each of those queries. It is much simpler to change the
criteria in a single query than in a dozen or more and would like to take the
latter approach but I am finding that the performance degrades too much to be
practical. My queries include pass-through queries and linked data sources.
Can I use a shared variable instead and would that help? I suppose the most
problematic query is the pass-through. Can anything be done to improve the
performance there? Any suggestions would be appreciated.
thanks,
Paul
I have a number of queries in an application that all reference a single key
field in a table to set the selection criteria for each query. I can either
set the criteria separately in each query or include another query that sets
the criteria within each of those queries. It is much simpler to change the
criteria in a single query than in a dozen or more and would like to take the
latter approach but I am finding that the performance degrades too much to be
practical. My queries include pass-through queries and linked data sources.
Can I use a shared variable instead and would that help? I suppose the most
problematic query is the pass-through. Can anything be done to improve the
performance there? Any suggestions would be appreciated.
thanks,
Paul