|Re: [CDO] Decomposing model into several repo & use same DB [message #987546 is a reply to message #987308]
||Tue, 27 November 2012 05:57
| Eike Stepper
Registered: July 2009
Am 25.11.2012 22:45, schrieb Cristian Mising name:|
> I would like to decompose my model into several repositories, that contain references between them. The reason for
> doing this: I would like to have some of the repositories stored locally. And because CDO doesn't allow a partial
> checkout of the repository, a solution would be the use of multiple repositories, instead of a single, bigger one.
> Question 1) is it possible that all my repositories use the same database? All the examples that I found about CDO: 1
> repo = 1 DB.
I think it should be possible (easy to try out), but it may depend on the physical system used. You may need to declare
separate schemas or so.
> Question 2) Should I expect severe performance penalties because of this approach? E.g. 1 resource/repo with 10000
> objects vs 10 resources/repositories with 1000 objects each vs 100 resources/repositories with 100 objects each?
Each repository has its own set of infrastructure services (revision manager/cache, package registry, security realm,
and, and, and...). You'd need additional server resources for all of them. Similarly for the sessions on the clients.
Inter-repo cross references (and containment proxies) are stored as URLs that need more storage space/bandwidth and that
can only be resolved by clients with properly configured resource sets).
Multi-repo commits require a CDOXATransaction which is somewhat complexer and more time consuming.
Unfortunately I can hardly comment on the exact performance differences. They depend on various things like the store
being used, the DB system being used, etc. If you make a prototype and measure yourself, I'd appreciate if you would
write them to the wiki and let us know ;-)
Powered by FUDForum
. Page generated in 0.01839 seconds