> >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
> to figure out which rows from table 2 belong to table 1 and building my
> 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

Reply via email to