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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
On 7/27/2011 4:16 AM, Tom Cloyd wrote:
> 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.
 
It would help to know what OS you're on and whether the file is a
self-contained ODB file or if it's accessing an externally-served database.
 
I run a fairly large database (much larger than the one you're talking
about) on Windows XP without any problems, and have for years. However,
I do not have it as a self-contained ODB file; I use LO/OOo as the
front-end and serve the database using hypersql. I found that doing it
this way dramatically speeded (sped?) up the process. You might try
converting over to that model.
 
I have heard that H2 DB is actually a bit better for this purpose and
that it's not tremendously difficult to convert over to H2 from
hypersql, but I haven't had the guts to try it yet.
 
- -- 
Steven Shelton
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
 
iEYEARECAAYFAk4wUx4ACgkQXUonIzCvpdMKQwCeK9FS5VO/OaM0t4z7wYQohYvS
5ksAoIb9eVadEnvo8HpBckfjo0VT0hH1
=G/Qm
-----END PGP SIGNATURE-----


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