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

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

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.

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