Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) Ahah, thanks Jay. I was hoping that HSql only dipped into using java for a few things. So, Don needs to have that java box ticked all the time he uses Base and can only avoid it when not using Base at all. Is it possible to edit short-cuts and stuff so that opening Base will enable java but opening java wont? I think it might be possible in GnuLinux by having 2 different short-cuts on the desktop or in the taskbar/panel. regards from Tom :) --- On Sun, 18/9/11, planas jsloz...@gmail.com wrote: From: planas jsloz...@gmail.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 6:58 Hi, On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 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. On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
On 17/09/2011 04:03, Don Myers wrote: This solved my problem totally. 1.6.0_21 works very fast with Base. 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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 :) --- On Sat, 17/9/11, Ian Whitfield whitfi...@telkomsa.net wrote: From: Ian Whitfield whitfi...@telkomsa.net Subject: Re: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 8:39 On 17/09/2011 04:03, Don Myers wrote: This solved my problem totally. 1.6.0_21 works very fast with Base. 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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 sitwait 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 :) --- On Sat, 17/9/11, NoOp gl...@sbcglobal.net wrote: From: NoOp gl...@sbcglobal.net Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 3:59 On 09/16/2011 07:03 PM, Don Myers wrote: On 09/16/2011 08:31 PM, NoOp wrote: On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote: 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? 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: Please provide a link to your bug reports (for both LO and Java). Thanks. ... -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: LibreOffice-Base CPU usage
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, 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 -- For unsubscribe instructions e-mail to: users+h...@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
Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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. --- Forwarded message --- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
GREAT! It is a day/night difference! On 09/17/2011 03:39 AM, Ian Whitfield wrote: On 17/09/2011 04:03, Don Myers wrote: This solved my problem totally. 1.6.0_21 works very fast with Base. 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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
On 09/16/2011 10:59 PM, NoOp wrote: On 09/16/2011 07:03 PM, Don Myers wrote: On 09/16/2011 08:31 PM, NoOp wrote: On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote: 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? 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: Please provide a link to your bug reports (for both LO and Java). Thanks. ... 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. -- *** * -- For unsubscribe instructions e-mail to: users+h...@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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 :) --- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote: From: Heinrich Stoellinger hc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org users@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Fwd: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 --- Forwarded message --- From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 14:29:10 +0200 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 :) --- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote: From: Heinrich Stoellinger hc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org users@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 On 09/17/2011 06:30 PM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:44 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 On 09/17/2011 06:30 PM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
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 On 09/17/2011 06:58 PM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:44 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 On 09/17/2011 06:30 PM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.atwrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi, On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 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 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. On 09/17/2011 08:29 AM, Tom Davies wrote: 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 :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 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. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 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, 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 --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View
[libreoffice-users] Re: LibreOffice-Base CPU usage
On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote: 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? -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice-Base CPU usage
On 09/16/2011 08:31 PM, NoOp wrote: On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote: 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? 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 (ToolsOptionsJava) 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 ToolsOptionsJava, 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 ToolsOptionsJava 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 -- *** * -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: LibreOffice-Base CPU usage
On 09/16/2011 07:03 PM, Don Myers wrote: On 09/16/2011 08:31 PM, NoOp wrote: On 09/16/2011 11:44 AM, Heinrich Stoellinger wrote: 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? 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: Please provide a link to your bug reports (for both LO and Java). Thanks. ... -- For unsubscribe instructions e-mail to: users+h...@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