Re: [PHP] PHP4/5 MySQL nested query problem

2004-08-22 Thread Kevin Wormington
l in loops, but not 5 seconds vs. several hours. Kevin On Aug 22, 2004, at 9:49 PM, John Holmes wrote: Kevin Wormington wrote: I have ran into an interesting query performance problem that occurs with both 4.3.7 and 5.0.1 against a MySQL 4.1 database. The test program (attached below)

[PHP] PHP4/5 MySQL nested query problem

2004-08-22 Thread Kevin Wormington
I have ran into an interesting query performance problem that occurs with both 4.3.7 and 5.0.1 against a MySQL 4.1 database. The test program (attached below) works, but performance is extremely slw, a perl version of the test program completes in less than 5 seconds with 80k records in ta