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

Am 28.07.2011 00:00, Tom Cloyd wrote:
> This is do not understand. I thought HYPERSQL was the default db engine.
> You say you're using it to server ANOTHER db? why not access that
> directly through Base? Am I misunderstanding something (entirely possible)?
> > I found that doing it this way dramatically speeded (sped?) up the
> > process.
> You don't way what your external db is, and I'm curious about this.
> > 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
> This is an interesting option, and I'm thinking that later today I'll
> install H2 and set up a test to see is the problem I'm experiencing
> vanishes. If not, then it's MYSQL, I guess.

Again: Under Linux any Java database is crawling unless you use one 
particular Java version which is 1.6.22.
I use Base documents with embedded HSQLDB 1.8, HSQLDB 2 server and H2 as 
well. The latter runs well with half a million records, a dozend 
relations and no Java other than 1.6.22
http://www.oooforum.org/forum/viewtopic.phtml?t=125253#436698


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