RE: [PHP] Speed/Efficiency Question: Large array into DB

2005-10-11 Thread Alan Lord
ginal Message- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: 11 October 2005 19:35 > To: Alan Lord > Cc: php-general@lists.php.net > Subject: Re: [PHP] Speed/Efficiency Question: Large array into DB > > Sounds to me like you are trying to import data. In which > c

Re: [PHP] Speed/Efficiency Question: Large array into DB

2005-10-11 Thread Brent Baisley
Sounds to me like you are trying to import data. In which case it would be best to create a text file and import it rather than putting PHP in the middle. But if you are going us to PHP, I would not do individual INSERTs. The overhead will really slow things down with number of inserts you