Performance when a query references another querie

[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)

 

[Stefan Hoffmann]

hi Jay,

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)

http://en.wikipedia.org/wiki/Crossposting
http://www.webhero.org/Newsgroups/crossposting.asp


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Jay,

oops, sorry. Wrong mail composing window...


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Jay,

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)

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