multiple data to insert to database
| From: | Alain Roger | Date: | Fri, 10 Aug 2007 13:36:45 +0000 |
| Subject: | multiple data to insert to database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-260570@lists.php.net to get a copy of this message | ||
Hi,
I would like to know what is the best way and fastest to insert into
PostgreSQL around 25.000 records (extracted from CSV file).
Should i use the standard pg_exec($dbconn, "insert into..."); for each
record ?
thanks a lot,
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.2.4
PHP 5.2.1