Re: WO Equivalent of prepared statement
Re: WO Equivalent of prepared statement
- Subject: Re: WO Equivalent of prepared statement
- From: Florijan Stamenkovic <email@hidden>
- Date: Mon, 27 Oct 2008 17:49:01 -0400
On Oct 27, 2008, at 17:04, Randy Wigginton wrote:
I am processing millions of rows of data, and the output is very
large tables. I would like to use an equivalent of
preparedstatements for my writing&updating; there is less need for
transactional integrity and more need of raw speed. Is there
anything in WebObjects or Wonder to help with this?
I understand I could use raw sql, but that would involve massive
amounts of parsing on the part of the database; a prepared
statement handle would allow me to simply pass values and minimize
the work needed by the database.
AFAIK, you can make a pre-compiled SQL statement on the db level,
make a "Stored procedure" that represents it in your EOModel, and
then tell EOF (also through the model) to use those procedures to
perform your inserts, deletes and fetches. I believe that would give
you exactly what you mention above, except for the updates. I've only
read about this, so I am not sure how well it works, if there are
problems with it.
If you are looking to perform other arbitrary operations on the data
in the same efficient way, that's quite easy. Prepare a statement in
your db, make a representation of it in the model (a Stored
Procedure), and call it from your WO Java code whenever it is
appropriate. I use this approach happily. I believe you should be
able to use it to perform updates.
All a part of standard WO, have no idea if wonder gets into this at all.
HTH
F
_______________________________________________
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