Hi Tom, In relation to the H2 database you said - > I get the impression that H2 is also a small, fast one but could easily be wrong.
All of my H2 databases would be classified as small, but a couple of years ago an H2 user posted on the Users Group that inserts to his data base slowed down significantly after it got to the 1 billion record mark! See - https://groups.google.com/forum/?hl=en#!searchin/h2-database/billion/h2-database/tB6QP8MeDj8/6tyTZ4s5kf0J ​You will notice from the thread that he got several responses on how to overcome his problem​ and these enabled him to improve the response he was getting. So I think H2 should be included in the list of heavy duty databases. But I must admit that it will probably be quite a while before I need a table with 1 billion rows in it! Noel -- Noel Lodge [email protected] On 11 July 2014 23:29, Tom Davies <[email protected]> wrote: > Hi :) > Actually HsqlDb from their own site is usually a huge improvement over the > internal back-end version and is apparently really good too. However i > think HsqlDb aims to be for small, light-weight but extremely fast > databases so it probably wouldn't suit this particular use-case. I get > the impression that H2 is also a small, fast one but could easily be > wrong. > > We often mention the heavy-duty back-ends such as Postgresql and > MySql/MariaDb but rarely hear about the faster, lighter-weight ones and how > they compare against each other. > > In general i think it is good to be reminded that there are other choices > out there and what some of them are. > Many thanks and regards from > Tom :) > > > > > On 11 July 2014 14:07, Marion & Noel Lodge <[email protected]> wrote: > >> Hi Dave, >> >> You might also like to have a look at the H2 Database Engine, see - >> http://www.h2database.com/html/main.html >> >> I have found that it is a good stable replacement for HSQLDB and have used >> it in 6 different databases with good success. There is an active users >> group, and some of them report success with very large databases. >> >> Noel >> -- >> Noel Lodge >> [email protected] >> >> >> On 11 July 2014 05:27, dave boland <[email protected]> wrote: >> >> > I'm setting up a database that is small (three tables, may grow to 3GB >> > over next year). I need a strategy to deal with the unknown, which is >> > how to add fields to an existing table. I read in the docs that doing >> > this can be painful and it is required to put something in each field >> > for each record. Do I have this correct? If so, how do I handle the >> > inevitable "...would you add..." that is sure to come within the next >> > few months? I would add them now, but I really can't anticipate how >> > many fields will be added or their requirements. >> > >> > In general, do other databases have similar restrictions? At some time, >> > when I have time, I will consider MySQL, MariaDB, and others. >> > >> > Thanks, >> > Dave >> > -- >> > dave boland >> > [email protected] >> > >> > -- >> > http://www.fastmail.fm - Or how I learned to stop worrying and >> > love email again >> > >> > >> > -- >> > 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
