Re: [PHP] multiple data to insert to database

2007-08-11 Thread brian
Richard Lynch wrote: 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 rec

Re: [PHP] multiple data to insert to database

2007-08-10 Thread Richard Lynch
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 la

[PHP] multiple data to insert to database

2007-08-10 Thread Alain Roger
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 Postgre

Re: [PHP] multiple data to insert to database

2007-08-10 Thread Robert Cummings
On Fri, 2007-08-10 at 15:36 +0200, Alain Roger wrote: > 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,