-----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 [email protected] 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
