Re: [libreoffice-users] Base out of memory

Hi :)
I have just found this old thread;
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=19016
and it might well still be very relevant.  Also this thread;
http://listarchives.libreoffice.org/global/users/msg08764.html

Err, do you know if you are using an external back-end to contain the
data?  If you are not sure then you are probably using the internal
back-end so that the whole database appears to be just 1 file.  Base
is much better when the tables are exported into an external back-end
that Base then just links to.  The internal back-end is just to help
those who are more familiar with MS's "Access" but Base is far more
powerful, thanks to it's ability to connect with a wide variety of
external back-ends.  Something small fast and powerful such as HSqlDb
might be ideal for your use-case even though it's built on Java;
http://hsqldb.org/
An ancient, heavily tweaked and very restricted form of HSqlDb was
squeezed into being the back-end for Base and there has been some work
into switching to a newer and more easily updateable internal back-end
but i am not sure about the progress.  Anyway the proper full releases
of HSqlDb perform much better than the internal version.

Sorry i am not being very helpful here!  Hopefully someone with a lot
more understanding and/or knowledge will appear or someone give some
other ideas worth trying.

Regards from
Tom :)

On 19 January 2016 at 12:51, Malcolm Moore <st-malcolm.moore@whsg.info> wrote:
> The error comes up before you have really had a chance to enter any data
> If you enter the first row and then start entering data in the second row the
> error pops as soon as the cursor goes to the first field in the second row.
>
>
> Mal
>
>
>
>  From:   Tom Davies <tomcecf@gmail.com>
>  To:   Malcolm Moore <st-malcolm.moore@whsg.info>
>  Cc:   "users@global.libreoffice.org" <users@global.libreoffice.org>
>  Sent:   19/01/2016 12:41 PM
>  Subject:   Re: [libreoffice-users] Base out of memory
>
> Hi :)
> I am not sure about the SQL error code and haven't even looked it up
> yet.  However it does sound like a quite small database that shouldn't
> be having any trouble with memory.
>
> As a quick first try maybe radically increasing the default settings
> in LibreOffice might help.
> Tools - Options - Memory
> The defaults are all for MUCH lower spec machines so you can easily
> allow LibreOffice to use much larger amounts of Ram.  Hmm, all the
> settings seem to be about graphics and objects so i'm not sure it
> would help.  I think it's still worth a try though.
>
> Regards from
> Tom :)
>
>
>
>
> On 19 January 2016 at 12:29, Malcolm Moore <st-malcolm.moore@whsg.info> wrote:
> > Can anyone point me in the right direction here
> >
> >
> > 2 users in a room of 32 users.
> > Design a table - name, DOB, phone number etc  no images or the like
> > Table saves OK
> > When you try and enter data it says
> >
> >
> > SQL Staus : S1000
> > Error code: 72
> > out of memory
> >
> >
> > Machines are openSUSE 13.2
> > 8G ram
> >
> >
> > Ta
> >
> >
> > M
> >
> >
> >
> > --
> > 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