Re: [libreoffice-users] Re: Base record access unacceptably slow

On 07/27/2011 05:03 AM, Alexander Thurgood wrote:
> 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
That command appears to have cut 5 seconds off the record pointer move 
test, and also off the full db search test I ran previously.

Tom

--
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