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.mo...@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 <tomc...@gmail.com> > To: Malcolm Moore <st-malcolm.mo...@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.mo...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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
