| [CDO] (How) does CDO support batch/bulk updates [message #873484] |
Fri, 18 May 2012 06:39  |
Eclipse User |
|
|
|
Hi,
(how) does CDO support batch/bulk updates?
My application is getting master data daily in a night run.
The master data makes up to 70 percent of the total data.
How can I combine/load the data with CDO?
Currently we import the data as normal CDOs, which results in bad performance.
Is there a way to do a bulk insert/update?
Thanks in advance,
Joe
|
|
|
| Re: [CDO] (How) does CDO support batch/bulk updates [message #873507 is a reply to message #873484] |
Fri, 18 May 2012 07:47  |
| Eclipse User |
|
|
|
Am 18.05.2012 12:39, schrieb Missing name Mising name:
> Hi,
>
> (how) does CDO support batch/bulk updates?
> My application is getting master data daily in a night run.
> The master data makes up to 70 percent of the total data.
>
> How can I combine/load the data with CDO? Currently we import the data as normal CDOs, which results in bad
> performance. Is there a way to do a bulk insert/update?
I know of no good way. All data instertions/modifications must happen in the scope of a transaction/commit for the
history to be correct.
Depending on various aspects, such as store type or DB vendor, it could be possible to tune for inserts. The DBStore,
for example, offers "WithRanges" mapping strategies for the auditing/branching modes with better insert/update
charecteristics. If you don't need auditing/branching make sure you switched them off.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Powered by
FUDForum. Page generated in 0.04449 seconds
Home