Re: multiple data to insert to database
| From: | Richard Lynch | Date: | Fri, 10 Aug 2007 23:56:52 +0000 |
| Subject: | Re: multiple data to insert to database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-260660@lists.php.net to get a copy of this message | ||
On Fri, August 10, 2007 8:36 am, Alain Roger wrote:
> 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 ?
25.000 records is not THAT large, so try it and see if it's acceptable
performance.
If not, ask the PostgreSQL list/forum how to bulk load a CSV file, as
it's not a PHP question, it's a PostgreSQL question.
--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?