Bug#488202: openoffice.org-base: even very small databases unusably slow

[Rene Engelhard <rene@debian.org>]

(please keep 488202 in the loop for answers which belong to the buglog )

Hi,

Lee Lindwood wrote:
>>> Trying to work with a tiny database containing like only one table with only
>>> about 830 records, things like editing and viewing reports are so ridiculously
>>> slow (on a 3GHz Intel Dualcore) that the software is almost useless. (Word
>>
>> welcome to Java. The database engine is pure Java. and if you use the
>> Report Builder extension, it's Java, too.
>
> Hm, I hate java. I never got it to work, and I've never seen anything involving
> java work well.

Yeah, but we have to live with it... Especially as Sun likes it..
(which still does most work on OOo)

>>> processing and spreadsheets are ok.)
>>
>> I believe you use gij as Java (Free Software Foundation" SDK in Tools ->
>> Options -> Java) without having -gcj installed. gij has no Java JIT
>> compiler, so it's slower than Suns Java for example *unless* you install
>> -gcj, at which time you get the speedup which -gcj provides by making
>> it possible to make the jars also available as native compiled code,
>> which obviously is fast.
>
> Yes, it says "Free Software Foundation". I installed the gcj package, but

Really "only" gcj or did you just not see the -? ;-) "gcj" of course
doesn't bring you anything :)

*I* mean openoffice.org-gcj.

> scrolling is impossibly slow. Do I need to do something with gcj to make
> it faster?

Yes, using *openoffice.org-gcj*.

Of course...

>> I don't think I need it, I think you want to install -gcj. If that
>> doesn't work for you sufficiently - well, as said: welcome to Java.

.. this still applies.

> Well, if it's like that, they still need to fix it. Saying "it's so

They won't. They can't go away from hsqldb now anymore...

> Take a look at Microsoft Access --- I don't like to say it, but that
> is the one application they have done pretty well.

lol

> Is there an alternative to openoffice for the database part? I don't

There's no "openoffice".

Regards,

Rene