Performance when a query references another querie

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

I have a SQL query which references three other queries. The form that is
tied to the SQL query opens rather slow. Will I improve performance if I
change the SQL query to pull from the 3 data sources directly. (right now I
only have about 12 sample records in my DB)
 
hi Jay,

Jay said:
I have a SQL query which references three other queries. The form that is
tied to the SQL query opens rather slow. Will I improve performance if I
change the SQL query to pull from the 3 data sources directly. (right now I
only have about 12 sample records in my DB)
Click to expand...
Rather slow with twelve records normally indicates that there is
something weired going on.

Are your referenced tables are in a local stored .mdb or on a network
drive?
Do you use a split application (front-end/back-end .mdb)?
Do you use some user defined VBA functions in your queries?
Do you create Cartesian products (which means in your actual case
12x12x12=1728 records)?
Do you use indexed fields for your join conditions?
What do you mean exactly with "3 data sources" - local tables or linked
tables or anything else?


mfG
--> stefan <--
 
Back
Top