via PHP (v4.3) it would either not LOCK the tables effectively, or
optimise the query differently than when running in the MySQL client?
If you are duly motivated, I could send you the exact query and a test
DB dump...
Thanks,
Scott
Marc Slemko wrote:
On Tue, 27 Apr 2004, Scott Switzer wrote
Hi,
I am having a difficult time with a query. My environment is MySQL
v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
Basically, I am running a query of the form:
INSERT INTO temp_tbl
SELECT c1,c2...
FROM t1,t2,t3,t4
WHERE ...
It is a very complex query, which looks at