![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes
this behaviour, could it have to to with backup copy creation? I find an aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like "rmodbc.odb_9777.odb" and are of 0 (zero)
size. I wonder what's wrong.
Regards
H. Stoellinger
And what happens if you turn off auto backup?
Hello again,
On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion
to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save
LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes
this behaviour, could it have to to with backup copy creation? I find an aweful
lot of backup files in /home/rainermusik/.libreoffice/3/user/backup.
All of them have a filename something like "rmodbc.odb_9777.odb" and are of 0 (zero)
size. I wonder what's wrong.
Regards
H. StoellingerAnd what happens if you turn off auto backup?
Hi All,
Base worked well for me in Windows since it was created while I was running Windows, and for two years in Ubuntu until the Java for Linux was updated from 1.6.0_22 to 1.6.0_24 last spring. At that point Base became almost unusable. In a database with 2500 records, instead of going from the first record to the last record in about 1 second, the time became 25 to 30 seconds. When I looked at CPU usage. 1 core would be running at 100% during this time. Java 1.6.0_26 then came out, and the same problem existed. About 5 weeks ago someone started a thread titled something like "Base runs unacceptably slowly." One person left a post stating that in Linux you can have more than one version of Java installed at the same time and left the following instructions:
Overview:
1. Download the JRE archive (approx. 20 mb)
2. Extract in /tmp
3. as root, copy the extracted directory to /usr/lib/jvm
4. set this JRE as the JRE of choice in LO (Tools>Options>Java)
5. Exit LO & restart
Instructions:
1.Download jre-6u21-linux-i586.bin (for i386) or jre-6u21-linux-x64.bin for
x86_64 from
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jre-6u21-b07-oth-JPR
JRE archive at ORACLE . Save to /tmp . Open Terminal and enter cd /tmp. Then do the following commands:
2.run it using: "sh jre-6u21-linux-i586.bin" . The JRE is now extracted to
/tmp/jre1.6.0_21/
3. copy to /usr/lib/jvm "sudo cp -a jre1.6.0_21/ /usr/lib/jvm"
4. Exit & restart office. In Tools>Options>Java, choose 1.6.0_21. Exit &
restart office
5. Load you Base file & compare the speed.
If you want to remove it simply set the JRE back to the old one in
Java & "sudo rm -rf /usr/lib/jvm/jre1.6.0_21/
This does not replace your current Java install in your browsers, or even show up in synaptic package manager. But it does show up as being available for LibreOffice. This solved my problem totally. 1.6.0_21 works very fast with Base. I haven't worried about security problems since the browsers are using the current versions, there isn't any plugin installed for 1.6.0_21 for the browsers, and also since it doesn't show up in synaptic. Does that mean there are not any risks? I don't know, but I would think any risk would be minimal.
The reason I think this might be your problem is because you have the same issue with CPU usage that I did.
Don
Please provide a link to your bug reports (for both LO and Java). Thanks.
...
After LOTS of problems with Base I also went this way and it works for me too!!!
I can recommend it to everyone using Base!!!! Almost perfect again!!!
Ian Whitfield
Hi 
Were you using OpenJdk before? Could you test-drive the _20 and _22 to see if they are as good as the _21? A few people say that the _20 or _22 are a huge improvement on things like the _24 or onwards. I am trying to convince someone to try the _21 but he is happy enough with the _20 and thinks there wont be much better than that.
Don't worry if you don't have time! I am just really glad to hear it works well for you
Regards from
Tom
Hi
Java is an unusual problem for LibreOffice. Most of the apps have either already moved away from it or are moving away fast. Java and OpenJdk are owned by Oracle. Do we have any confidence in
them fixing things so that their products work better for LibreOffice? Currently the newer the release of Java the more problems there seems to be in using it in LibreOffice.
I don't think there was a bug-report. There are almost no devs working on Base so posting a bug-report is not likely to yield any positive results for months, maybe years. Also if devs do start working on Base it would be good to follow the rest of the project away from java. Inevitably devs are going to have to start by fixing bugs but any work they do to fix problems with java will have been a bit of a waste of time after java is written out.
It's NOT ideal for LO but we have to deal with things as they are rather than how we would like them to be. We can temporarily work-around problems by using the _21 (or _20 or _22) and by trying to encourage people to develop Base's code.
The SC wants to sit&wait to see if anyone happens to notice that working on Base might be a rewarding challenge. When pushed they thought it might be nice to make a questionnaire to send to people who don't need a database program to ask them what they want from a database.
Regards from
Tom
Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing.
Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
Hello again,
Is there a misunderstanding somewhere? As I said, I use the ODBC-connection
to MySQL on Linux (and a very well working native MySQL-connection under
Windows). Like I posted in another message, ODBC also has problems (such
as not showing default values for columns correctly on data entry, but -
since the database is actually updated correctly - this doesn't really
worry me much.
So, like Tom suggests: can I get completely rid of Java if I don't
conciously use it in any way that an end-user or programmer could cause?
That would be more than alright for me...
Regards
H. Stoellinger (from a lovely early autumn sunny day here in Salzburg)
P.S.: I have used the Java-connector in the past but don't do so anymore.
GREAT!!!!!!!!! It is a day/night difference!!!!!!!!!
I think the LibreOfice bug report was closed when the workaround was discovered. I think a notice was sent out to that effect. I don't know what had been filed with Java. One would have thought when OpenOffice and Java were both owned by Oracle that there would have been some communication between them. The problems stated before Oracle disposed of Open Office.
Hi
I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it.
Tools - Options - LibreOffice/General - Java
then UNtick the box at the very top "Use a java runtime environment". I have only unticked this a few days ago and LO seems to start-up a lot faster.
Regards from
Tom
Hello Tom,
Thanks for your suggestion. I unticked the box at the very top "Use a java runtime environment"
and LO still works fine. It also starts up very fast.
As I need Java for purposes outside of LO, I will keep it for the time being.
Regards
Heinrich
Hi All,
I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message:
The connection to the data source "RE Database" could not be established. No SDBC driver was found for the given URL.
I cannot open my database without Java enabled. So using the database included with base will not work without Java.
Don
Hi
Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong.
Regards from
Tom
Hi Tom,
There is an old saying - if it ain't broke, don't fix it. The thing I dislike most about Base is to have to open three windows to get to my form in the database. Some time ago I left a post on an Open Office forum asking if there was a way to set up a macro so I could do it in one click. There were never any replies. With Paradox or Access I was able to go to the form by just opening the program. But what I really like about Base is I just have 1 file to copy to keep my database updated on my three other computers. When I say "if it ain't broken, don't fix it", I've never had one issue using Base. It has worked very well for me over a long period (7 or 8 years) of time. There are few programs I've ever used that have had that kind of dependability.
Don
Hi
If the different machines are on a Lan then it might be possible to share the back-end and then any change from any of the 3 machines would be on the other machines too?
Regards from
Tom
Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms.
All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing.
Am 16.09.2011 20:44, Heinrich Stoellinger wrote:
Thank you Tom,
Only one of them is on the same network. That is basically a backup computer. The other two are at a different location and are not networked with the first two.
Don
Hi,
Hi
Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong.
Regards from
TomFrom: Don Myers <donmyers@myersfarm.com>
Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
To: users@global.libreoffice.org
Date: Saturday, 17 September, 2011, 23:13Hi All,
I set up base shortly after it was added to Open Office. Apparently I am
using the embedded database - HSQL database engine. If I turn off Java
(I just tried it.), I get the following error message:
The connection to the data source "RE Database" could not be
established. No SDBC driver was found for the given URL.I cannot open my database without Java enabled. So using the database
included with base will not work without Java.Don
snip
The HSQL engine is Java based. It may be possible to use Base as a
front-end for something like MySQL or PostgreSQL, which do not use Java.