Am 17.03.2012 21:20, Mark Stanton wrote:
I would suggest replacing the bastard (are we really talking like this? :-) ) with MySQL or perhaps even better MariaDb (mebbe even Postgres).
Replacing one excellent databse engine with another excellent (much bigger) database engine will not solve any problem.
I run a HSQLDB server and it is the most reliable and fast little software on that Windows machine. On my Linux laptop I run the exact same Java software in cached mode, just like the embedded one but as an independent process with database files outside the Base document.
The "embedded HSQLDB" works like an extension. Every time you access the package data, the database gets installed to <office temp>. When you close the last connection to the installed database, the database is repackaged into the .odb "document". As the database grows, this thread consumes more and more time and during that time there must not happen anything serious to the office suite. IMHO HSQLDB is a well thought choice for a multi-platform database. However, databases should be installed as extension packages so the user data won't be shuffled this way.
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted