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

[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

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, Let's

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 large,