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 Myers<donmyers@myersfarm.com>  wrote:
>
> From: 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: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 Stoellinger<hc.stoellinger@aon.at>   wrote:
> >
> > From: Heinrich Stoellinger<hc.stoellinger@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"<villeroy@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+help@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+help@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