MySQL Forums
Forum List  »  Optimizer & Parser

slow subquery
Posted by: Michael Schnell
Date: December 01, 2005 03:33AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
slow subquery
6578
December 01, 2005 03:33AM
2897
December 07, 2005 08:18AM
2708
December 09, 2005 02:32PM
2647
December 19, 2005 11:58PM
3147
December 30, 2005 12:43PM
3389
December 30, 2005 02:25PM
2606
February 22, 2006 01:06PM
5203
February 23, 2006 08:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.