Issues with Sub-selects and performance on Win 2003
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.
Adam
Subject
Views
Written By
Posted
Issues with Sub-selects and performance on Win 2003
3744
November 05, 2004 07:01AM
2462
November 06, 2004 03:23PM
2401
November 11, 2004 09:05AM
2453
November 11, 2004 07:11PM
2414
November 12, 2004 05:49AM
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.