Re: Database update and insert optimizations?

Thu, 27 Jul 2006 17:01:12 -0700

Further to my post, here's an interesting article I found about why using Prepared Statements are good and how to use them properly:



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 

On Jul 27, 2006, at 5:52 PM, Brendan Duddridge wrote:

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      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to