Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 12 of 12 total |
Slow/funny query progress |
Wed, May 2 2007 3:17 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Kerry
SELECT INTO creates the table for you. Roy Lambert |
Wed, May 2 2007 3:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kerry,
<< Anyway, if you can see a faster way to run the query, I would appreciate it. >> Well, the issue is what I thought it was originally. The userauthority_offices condition in the WHERE clause doesn't filter any rows for the joins because the join is on the OfficeID column, therefore the query has to perform ~35,000 X 4 X 2 joins in this query to generate the result set, or ~280,000 joins. That's what is taking so long. The only solution is to filter the rows a little better by being more selective in your criteria for the WHERE clause. If that's not possible, then you'll have to live with the execution time. When I get a chance, I'll migrate the data and run it against EDB and see how fast it goes. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |