Hi, Has anyone done any work to optimize the way EOF saves to the database? To be more specific, I was wondering if it would be possible to coerce EOF to use prepared statements instead of individual statements for each operation? So instead of: INSERT INTO table1 (col1, col2) values (1,2); INSERT INTO table1 (col1, col2) values (3,4); each executed as independent statements within a transaction, EOF could issue: PreparedStatement insertOp = con.prepareStatement("INSERT INTO table1 (col1, col2) values (?, ?)"); and then pass all the values using lower level jdbc: insertOp.setInt(1, 1); insertOp.setInt(1, 2); etc... I'm not sure of the exact jdbc syntax involved in doing this correctly. I just found a few notes about prepared statements on the Net. Has something like this been done or is it even possible? I would think this king of approach would make inserts, updates, and deletes faster. Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com |
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to archive@mail-archive.com