Hi, I have a couple of queries that look something like this:
Query1
Query2Code:SELECT a.SampleID, b.Taxa, a.Subtable FROM tblAll as a, tblAll as b;
tblAll has around 39,000 records, and Query1 should result in about 500,000 records. Query1 has successfully run (i.e. shows up in datasheet view) but still takes ages (I haven't left it to complete) to produce or display all the rows. I have now converted Query2 to a make table query so that I won't have to run it over and over.Code:SELECT Query1.SampleID, Query1.Taxa, tblAll.Count, Query1.Subtable FROM tblAll RIGHT JOIN (Query1.SampleID = tblAll.SampleID) AND (tblAll.Taxa = Query1.Taxa);
It's been running for about 4 hours now and Access says it is not responding, but I think it's still going.
I'm new to access and am trying to understand what it is that makes the query slow down so much. Is it simply because I am trying to create such a large number of records?
Can you see any way to edit the above query(ies) to make anything run faster?
It turns out that Queries 1 and 2 should result in roughly 1.9 million rows each. Is this way too many?