Malcolm,
> e. We tried a single database instance with a separate catalog for each
> company, but performance started to suffer.
>
Can you describe that experiment in more details?
- Did you try to increase buffers?
- What is the total size of the data in Sedna?
- How did you measure performance - I mean what kind of queries/updates
did you use?
- What was the database structure - one collection/multiple
collections/multiple stand-alone documents?
> Does the concept seem reasonable?
>
Probably. No one tried it so far, AFAIK. From the other side, if there are
few clients at every moment why the single-database solution doesn't work?
Are there any limitations or issues with using Sedna in this way?
The only one strong limitation is that "Sedna's database" is very heavy -
buffers, a lot of IPC objects (e.g. semaphores), etc. You will need to
rebuild Sedna and most likely to tune your OS to run so many databases at
once.
Ivan
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
