Re: [libreoffice-users] Adding fields to existing Base table

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
lodgemn@gmail.com


On 11 July 2014 23:29, Tom Davies <tomcecf@gmail.com> 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 <lodgemn@gmail.com> 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
> > lodgemn@gmail.com
> >
> >
> > On 11 July 2014 05:27, dave boland <dboland9@fastmail.fm> 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
> > >   dboland9@fastmail.fm
> > >
> > > --
> > > http://www.fastmail.fm - Or how I learned to stop worrying and
> > >                           love email again
> > >
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@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
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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