slow subquery

[Michael Schnell]

I'm using "ThumbsPlus" as a photo database.

Up till now I'm using it with the Windows "JetEngine" as a database backend.

As the database grows I'm going to hit the 2 GByte limit of the JetEngine.

So I'd like to migrate to MySQL.

It's known that ThumbsPlus does work with MySQL, but OTOH it's known that it works very slow in certain operations. The cause is known to be that ThumbsPlus issues a query with a subquery with drive, path and filename of a picture file to be listed. If there are many files in a directory the query seems to take minutes to get a result, because the subquery is unappropriately optimized. The JetEngine and MSSQL don't show this problem.

There is no chance to modifiy the ways of TP. Can MySQL be configured in some way to do a better (or different) subquery optimization. Will a future version of MySQL avoid that kind of problems ?

Thanks,
-Michael