Batch inserts
Batch inserts
- Subject: Batch inserts
- From: Charles Koppelman <email@hidden>
- Date: Wed, 19 Dec 2007 12:45:51 -0500
- Thread-topic: Batch inserts
So ERX provides us with a great way to do massive updates
(ERXEOAccessUtilities.updateRowsDescribedByQualifier). Is there a way that
anyone on this list has come up with to do massive INSERTs?
Looking at the code, it seems that inserts are done exclusively through
insertRow methods, meaning one insert statement per row. However, SQL
supports multiple inserts into the same table like:
INSERT INTO MY_TABLE
(ID, COLUMN_A, COLUMN_B)
VALUES (1, 'A', 'B'),
(2, 'C', 'D'),
(3, 'E', 'F');
Has anyone implemented this?
Charles Koppelman
Programmer
Youth For Understanding, USA
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden