> >From my experience, I found this: > > Selecting 1000 records from 2 tables using a join, 10secs and up.
I'd say you have a problem in your database / table configuration, i.e. indexes. There's no way a join between two tables that are properly indexed should take 10 seconds for only 1000 rows. > Selecting 1000 records for table 1, all records from table 2, then using php > to figure out which rows from table 2 belong to table 1 and building my own > combined array, less than a second. You're using a lot more memory on the server, though, by building up a huge array and recordsets. But, RAM is cheap... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
