| [CDO] (How) does CDO support batch/bulk updates [message #873484] |
Fri, 18 May 2012 06:39  |
 Joe Sobeos
Messages: 12
Registered: May 2012 |
Junior Member |
|
|
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  |
Eike Stepper
Messages: 5148
Registered: July 2009 |
Senior Member |
|
|
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.01453 seconds
] 
Search
Help
Register
Login
Home
