Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Le 27/07/11 10:16, Tom Cloyd a écrit :

Hi Tom,


Just to move the record pointer from the first to the last record takes
almost exactly 20 seconds. To do a search of the beginning of the main
text field for a 6 character string that isn't there (i.e., the engine
searches to the very end of the table) takes 2 minutes and 5 seconds.
You can imagine how long it takes to locate and update 10 records. This
is the worst performance I've ever seen in a database, period.

Unfortunately, you are not the first, and no doubt the last either, to
report performance issues using the Base with integrated hsqldb. The
problem is not hsqldb, which actually on its own performs quite well,
but the manner in which Base loads everything into memory to be able to
work.

You could try issuing a SHUTDOWN COMPACT command from the Tools > SQL
dialog, then saving and closing your ODB file before re-opening it again.

Alex


-- 
Unsubscribe instructions: E-mail to users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.