Hi :) I think it's worth avoiding using the internal back-end. Until very recently the internal one was an ancient and heavily tweaked version of Hsqldb. I think the devs have been working at replacing it with a more straight-forward Firebird and hopefully that will be updated in some sort of reasonably automatic way with an opt-out clause.
The old internal Hsqldb one was a bit warped and the new Firebird one is a bit new. If you get a reasonably recent version of Hsqldb to use as an external database then apparently it's extremely good and exceedingly fast, for small databases (such as address-books) but when using the internal tweaked version people have had some fairly serious problems. It's entirely written in Java apparently but even so it's allegedly quite good. Regards from Tom :) On 11 March 2014 22:41, jomali <[email protected]> wrote: > Thanks, Alex, for the clarification. Since I have never used the internal > hsqldb database, I was unaware that it kept its data in the .odb file. The > last internal database I used was Adabas D in Staroffice. I quickly went to > JDBC or ODBC connectors to other external datbase engines (e.g., MySQL). > John > > > On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood > <[email protected]>wrote: > >> On 11/03/2014 13:23, jomali wrote: >> >> Hi John, >> >> > I think your confusion lies in equating an .odb file with an Access >> > database. The .odb file never contains the data. It is a sort of registry >> > that points to wherever the data is. Thus, Base is the front end, a real >> > database is the back end, and the .odb file serves as the intermediary >> (to >> > oversimplify). >> >> I agree with everything you have written, except that, by default, if >> you use the wizard to create a "standard" (and I use that term very >> loosely) ODB file, LO creates an ODB file which embeds its own >> hsqldb-compatible data into the file and then uses the LO-shipped >> hsqldb.jar to be the db engine. This is where it gets confusing for >> people wanting to split out their data from their forms, queries, >> reports, etc. >> >> Alex >> >> >> >> -- >> To unsubscribe e-mail to: [email protected] >> 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 >> >> > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
