Saint X wrote:
Hi, I have a program that need to send a Postgresql database a lot of rows, i'm doing it using FOR an INSERT, something like this for i = 0 to 1000 { insert into table(item1) VALUES (i); }
And so on, as you can imagine these consume a lot of resources and move so slowly, that's why I'm looking for a command to send more than one row at the time, something like
insert into table (item1) values ('1' / '2' / '3' / '4' ... / '1000');
You can do instead:
insert into table (item1) values ('1');
insert into table (item1) values ('2');
....
insert into table (item1) values ('1000');As single query.
But better use COPY command or prepared statment.
Inserts slow commonly due to indexis and foreing keys.
-- Olleg Samoylov
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
