MySQL Forums
Forum List  »  Optimizer & Parser

Issues with Sub-selects and performance on Win 2003
Posted by: Adam Reynolds
Date: November 05, 2004 07:01AM

I've migrated my Access dbs (one was approaching 166MB) to a 3.5.1 MySQL installation. Then discovered that the sub-selects where still not in. Migrated to 4.1 and everything is fine until I run a subselect.

CPU usage on the mysqld-nt.exe goes to 100% and I have to kill the service.

Any thoughts? (Converting to joins is an option I don't want to approach).

Thank you.


Options: ReplyQuote

Written By
Issues with Sub-selects and performance on Win 2003
November 05, 2004 07:01AM

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.