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

2004-08-22 Thread Kevin Wormington
My "real" application has inserts and does other various forms of processing in the loops which cannot be done from pure sql via join, etc. The test program I attached was just the minimum required to see the performance issue. I agree that PHP is probably a little slower that perl in loops,

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

2004-08-22 Thread John Holmes
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) works, but performance is extremely slw, a perl version of the test program completes in less than 5 seconds