Subject Re: derived table within EXISTS (was: Different performance Superserver VS. Embe
Author danyschaer
Hi Milan,

I built a new copy of my database, with just the 3 tables involved in
my test: PROC, TPRO, MOVI.

To clarify:

http://www.lex-doctor.com/daniel/danydata.zip (full database with
full data)
http://www.lex-doctor.com/daniel/danyempty.zip (full database
strucutre, no data)
http://www.lex-doctor.com/daniel/danyshort.zip (full database
strucutre, only involved tables)

Danyshort.zip is 7 MB aprox.

A VERY SPECIAL POINT IS:

MOVI has a BLOB field called TEXT. In the database uploaded into
danyshort.zip, I do not added data to that column. Testing with this
database, same test, reduced needed time from 10 minutes to 35
seconds.

Sorry if that has something to do with this issue, I didn't say that
before because I didn't see problems in other areas of our proyect,
and also the other engines worked fine too.

Dany.