[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Base record access unacceptably slow
- Subject: [libreoffice-users] Base record access unacceptably slow
- From: Tom Cloyd <firstname.lastname@example.org>
- Date: Wed, 27 Jul 2011 02:16:50 -0600
- To: LibreOffice User's Help Forum <email@example.com>
This has been a problem from the beginning, and it's becoming intolerable.
The principal table in my database has about 550 records, with about 20 fields each. A number are binary in type, and two are memo, with the rest being text or foreign keys. Almost all the memo fields are empty.
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.
Indexes exist on the primary key and on the primary text field. It seems to make no difference. As the engine reports its progress during the search, it appears to be doing a serial search through every record.
At this rate, I'll be unable to make meaningful use of this database in about a week.
Is there anything at all I can do about this appalling situation?
I hope I just missing something that can be pointed out to me. But information on indexes is essentially nonexistent. There's none in the LO "book", or the Help file, or the underlying HYPERSQL engine's documentation. Amazing, but true.
I do hope someone has some ideas for me.
Thanks in advance.
Unsubscribe instructions: E-mail to firstname.lastname@example.org
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
|Re: [libreoffice-users] Base record access unacceptably slow||Steven Shelton <email@example.com>|
|[libreoffice-users] Re: Base record access unacceptably slow||Alexander Thurgood <firstname.lastname@example.org>|
|[libreoffice-users] Re: Base record access unacceptably slow||Andreas Säger <email@example.com>|
- Prev by Date: [libreoffice-users] Re: Reproducible crash when entering (Mart
- Next by Date: [libreoffice-users] Re: Base record access unacceptably slow
- Previous by thread: [libreoffice-users] Calc. Changing format of data types
- Next by thread: [libreoffice-users] Re: Base record access unacceptably slow