I must assume you have all the proper indexes setup and your
configuration variables are fairly optimal.
First, I would run just the select part with an explain in front of it
to see what MySQL is trying to do. I've had MySQL run a query for an
inordinate amount of time on a fairly small data s
I have been trying to run an fairly large INSERT into an
empty table joining two other tables now for several weeks and have not been
able to get the query to run to completion even when sub-seting the data into smaller
ranges.
I have tried this at MySQL releases 4.1.8a and 4.1.10a wit
