Ask Your Question
0

LO Base is much more slower under Ubuntu then under windows XP (the same DB, the same computer) [closed]

asked 2012-02-24 11:38:24 +0200

bolodya gravatar image

updated 2015-10-15 15:35:53 +0200

Alex Kemp gravatar image

So here is my observation.

I created an ODB file in LO Base on windows XP, and imported some data in to it from my previous DB (from .MDB through .ods as described in help). And database works well in windows. But... when I open this file in LO Base under ubuntu (on the same computer!!) and try to see data in tables, it works SO SO SLOW. it takes minutes to move to next page of records in one table, cpu usage is 100% all time. I experience such problems with table with ~1700 records, and with table with ~150 records also... all tables contains some integer and some varchar fields with 20 letters.

I tried to play with LO memory settings (as described on some forums) - no any result. I tried to import data into Base under ubuntu also - no any result. I moved data file from ntfs to ext4 partition - no any result.

And I am sure that I am not alone with such problem. google showed me some same questions... without solutions...

So do anyone here has such problems? any ideas what to do?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 15:36:05.317005

2 Answers

Sort by » oldest newest most voted
2

answered 2012-02-24 23:12:41 +0200

bolodya gravatar image

updated 2012-02-24 23:13:52 +0200

Got an answer. Hope it will help to anyone also...

it is a known bug with java engine, here its live https://bugs.launchpad.net/ubuntu/+source/sun-java6/+bug/724217

for me worked following:

  1. removed sun-java6-bin package (it was buggy 1.6.0.26)

  2. added repository "deb http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu Lucid Main" (it is for 10.04)

  3. added package sun-java6-bin (1.6.0.21 version)

  4. in LO settings-java selected 1.6.0.21 java engine

now it works well, and i am happy:)

edit flag offensive delete link more

Comments

1

Please mark your own answer as Correct so that your question is considered answered. Thank you for sharing the solution!

Pedro gravatar imagePedro ( 2012-03-13 18:37:44 +0200 )edit
0

answered 2012-03-13 17:58:36 +0200

AnnB gravatar image

Hi, I have had better performance since upgrading to LO 3.5.0. Is that what you're running on your Ubuntu partition?

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-02-24 11:38:24 +0200

Seen: 339 times

Last updated: Mar 13 '12