As for MySQL, if the table that you are inserting to has any indexes at all, then each time your insert/update completes MySQL will re-index the table.
That'll happen for any database (I don't know that it really re-indexes, rather it has to update the index instead).
Therefor, if you can batch the data like Rob suggested, then it will cut down on the number of re-indexes and speed the process up substantially.
Only postgres 8.2 supports that syntax so that may be another caveat :) -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
