Hi,
Federico Piccinin wrote:
Hello everybody, i'm usingo ojb 1.0.1 with oracle.
Suppose i want to do the following update:
Update table set column_name = value where condition;
the update involves about 100000 records.
with an SQL query the execution time is about 4 seconds, but using OJB with ODMG api the execution time is about 320 seconds, using PersistenceBroker the execution time is about 200 seconds (becouse ojb make about 100000 update!).
Is it possible to use sql directly for massive update or there are other tecniques ? Any suggestion.
No problem you can use SQL directly. Please have a look at FAQ in Documentation or see
http://db.apache.org/ojb/docu/guides/connection.html#obtain-connection
E.g. if you want to rise the price about 15% for all Article, then it doesn't make sense to materialize all Article, change the price and store the changed Article. This could be done within a single sql-query.
For all CRUD operations the overhead of PB-api against plain JDBC is about 10%.
regards, Armin
thanks
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
