Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
UNIONed query causing ElevateDB Manager to hang |
Sat, Feb 14 2009 11:13 AM | Permanent Link |
"Hedley Muscroft" | Me again (sorry!)
This is a follow-on problem from my previous post "Slow JOINs with VIEWs" :- http://www.elevatesoft.com/newsgrp?action=openmsg&group=16&msg=8613&page=1 The SQL for the UNIONed query is attached to this post. You can download the DBISAM 4 database here :- http://files.pioneersoftware.co.uk/temp/dbisam_testdb.7z You can download the ElevateDB UNICODE database here (to save migrating it yourself) :- http://files.pioneersoftware.co.uk/temp/edb_testdb.7z The results I get on the exact same data with the exact same SQL (attached) are as follows :- DBISAM4 = between 3 and 3.5 seconds ElevateDB Manager = hangs (left it for over 10 minutes) Hope someone can help! Thanks in advance. PS: if you can't open the 7zip files, you can download it free here :- http://www.7-zip.org Attachments: unioned_query.sql |
Sat, Feb 14 2009 9:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hedley,
UNION queries are not completely optimized in ElevateDB, so you may see poor performance compared to DBISAM. It's another thing that's on the list for 2.03, but you know the story there.... -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Feb 15 2009 4:49 AM | Permanent Link |
"Hedley Muscroft" | Ok - probably the best thing to do for now is to run separate SELECTs then
append the DataTables in code. Thanks for the info Tim. |
Mon, Feb 16 2009 12:07 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hedley,
<< Ok - probably the best thing to do for now is to run separate SELECTs then append the DataTables in code. >> I'm going to try to get a fix for this in 2.02 B8. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |