Good Monday Morning everyone :-), I have spent some time browsing through the archives but still am undecided on the question:
Considering a (web based) XML Document Management System designed to upload, query and edit(!) thousands of large (>>1GB) and small (~500k) XML Documents would you (I) rather put each document in a separate database or (II) put them all into one large database as stand-alone documents? From my point of view: Option I: Separate Databases + Isolation: If one database crashes, the others are unaffected + Database files only get as large as they need to be for one document + Updates or removals of documents will not effect performance - Cannot (or should not?) keep all database sessions opened at a time for sake of memory usage. So a robust management to open and close the sessions (se_sm / se_smsd) is needed. I have written a Java-Based Pool for that which automatically closed idle sessions after a while- however Iam not too happy about that solution Option II: + No efforts needed for session management. Just start one session and be happy + Possibly make use of queries over several documents if desired - VERY Large Database File. I have Bulk Uploaded 100 x 41 MB XML Code and there is no negative on performance. However if I have thousands of large (>1GB) and small (~500k) Documents which may in part be updated... how will Sednas performance scale? - Is it possible to use one database but configure Sedna to distribute data over several files as e.g. InnoDB storage backend does? I would really appreciate any comments and hints on best practise. Regards, Rüdiger ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Sedna-discussion mailing list Sedna-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sedna-discussion
