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?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to