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.
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
Context
- [libreoffice-users] Base record access unacceptably slow · Tom Cloyd
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.