Re: Slow HSQL database

Mechtilde <[email protected]> Sun, 21 Feb 2010 10:30:02 +0100
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hello Steve,

Corghi schrieb:
> Hy users,
> i have  a problem with a database of 26 mb and a table of 142000 record.
> It's quite impossible to work with it every database operation require a
> lot of time.
> Can someone give me suggestion for this matter?

This a a normal behaviour of the internal HSQL DB

> It's better a different database like postgres or mysql?
> 26 mb is not a big database... isn't it?

For the internal HSQL DB it is a big database. I think it isn't a big
database vor mysql or postgres ot an external HSQl server

Regards

Mechtilde


-- 
Dipl. Ing. Mechtilde Stehmann
## http://de.openoffice.org
## Ansprechpartnerin fÃŒr die deutschsprachige QA
## Freie Office-Suite fÃŒr Linux, Mac, Windows, Solaris
## Meine Seite http://www.mechtilde.de
## PGP encryption welcome! Key-ID: 0x53B3892B