[libreoffice-users] Re: Base record access unacceptably slow

2011-08-05 Thread Ian Whitfield
Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_ important for many users and some 'Official' Feedback' is VERY necessary. There are lots of very important points made in

RE: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-05 Thread Tony Royston
14:46 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Base record access unacceptably slow Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_ important for many

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-05 Thread Don C. Myers
August, 2011 14:46 To: users@global.libreoffice.org Subject: [libreoffice-users] Re: Base record access unacceptably slow Hi All As I reported recently I wrote to a contact I have in regard to this thread. Part of what I said was . /*PLEASE DO* follow up on this - I think it is _VERY_

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-02 Thread Don C. Myers
Hi Tom, I installed 1.6.0_21 on my home computer last night and compared it to 1.6.0_22. This is a 5 year old laptop with an AMD T-50 processor and 2 gigs of ram. It is far from a powerhouse, but it works very will with Ubuntu. Both versions of Java work very well with Base. 1.6.0_21 is a

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Ian Whitfield
On 30/07/2011 19:37, Don C. Myers wrote: Magnificent!!! Thank you, ponsiarceds! I followed your instructions for having an older version of Java along side the present one. I'm running Ubuntu 11.04 with the LibreOffice version of 3.4.1. Now base works really fast like it always

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Don C. Myers
Hi Ian, For some reason not all of the previous text I was responding to showed up in that post. This information I used was from a post from ponsiarceds. I'll paste everything below. Just make sure you are consistent with either jre or jdk in the instructions. The instructions have the two

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread Tom Cloyd
Some clarification: The JRE is sufficient (and smaller) if you just want to USE Base. I will absolutely attest to 1.6.0_21's being an order of magnatude faster than BOTH ...0_26 AND ...0_22, for me. The difference is very dramatic. Since running with ...0_21 my Base applications are simply

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-08-01 Thread planas
Ian, On Mon, 2011-08-01 at 17:36 +0200, Ian Whitfield wrote: On 30/07/2011 19:37, Don C. Myers wrote: Magnificent!!! Thank you, ponsiarceds! I followed your instructions for having an older version of Java along side the present one. I'm running Ubuntu 11.04 with the

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread Regina Henschel
Hi Tom, Tom Davies schrieb: Hi :) It might be time to cut Base loose. Most versions of MS Office don't include Access. Gnome Office doesn't have a database program. Perhaps Office Suites just don't need an integrated program to do this sort of stuff. Maybe Calc is enough. There are a few

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread Ian Whitfield
Hi All I have contacted someone I know who is on the Steering Committee, and is a Founding Member, of 'The Document Foundation' and he has replied to me asking for the full details. He is not involved on the Base side of the project himself but I have asked him to pass the information on to

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread soumalya ray
gr8.base users might feel betrayed now if base support is discontinued.that will not be a good experience for them.though personally i do not use base myself. best wishes On 31 July 2011 16:19, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All I have contacted someone I know who is on the

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread aon . 913450908
Hello, -- 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/

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread Andreas Säger
Am 30.07.2011 23:07, Jean-Francois Nifenecker wrote: Le 29/07/2011 10:41, Andreas Säger a écrit : As a matter of fact you can disable/remove Java, hit F4 ... connect, query, edit and dump. If I would convert our Java databases and remove Java from our systems nobody would notice the change.

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-31 Thread Andreas Säger
Am 31.07.2011 02:41, Tom Davies wrote: Hi :) It might be time to cut Base loose. Most versions of MS Office don't include Access. Every version I used to know included MS Query. MS Query is the equivalent of the Base core functionality. Base is much more important than MS Query. There are

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread David Nelson
Hi, On Thu, Jul 28, 2011 at 9:02 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: I think it's more a case of working on several fronts within TDF. 1.   joining the Steering-Discuss mailing list and promoting the cause there. Tom's right. I can definitely recommend taking time out to join the

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Tom Davies
: [libreoffice-users] Re: Base record access unacceptably slow Hi On Fri, 2011-07-29 at 17:55 -0700, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Don C. Myers
Magnificent!!! Thank you, ponsiarceds! I followed your instructions for having an older version of Java along side the present one. I'm running Ubuntu 11.04 with the LibreOffice version of 3.4.1. Now base works really fast like it always did. Then only thing I did differently

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Tom Cloyd
I may have seen this too late to join in, but I'll make the next one for sure. Thanks very much for the tip. I agree with Tom, too, in theory. The problem is that my resource account is already overdrawn. I have nothing left with which to make a heavy investment, anywhere. If it's just a

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Don C. Myers
One thing to be careful of. You can use either the jre or the jdk. The jdk is basically for developers and not needed by most folks. Make sure when you follow the instructions below you use one or the other. On 07/29/2011 08:55 PM, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Jean-Francois Nifenecker
Le 29/07/2011 10:41, Andreas Säger a écrit : As a matter of fact you can disable/remove Java, hit F4 ... connect, query, edit and dump. If I would convert our Java databases and remove Java from our systems nobody would notice the change. Could you elaborate, please? If I remove Java, can I

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Tom Davies
Hi :) The main thing is that you found a way to solve your current problem. Congrats and regards from Tom :) From: Tom Cloyd t...@tomcloyd.com To: users@global.libreoffice.org Sent: Sat, 30 July, 2011 18:51:02 Subject: Re: [libreoffice-users] Re: Base record

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Tom Davies
. Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Fri, 29 July, 2011 9:41:30 Subject: [libreoffice-users] Re: Base record access unacceptably slow Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Tom Cloyd
that the other apps don't need. So, lets just drop Base. Regards from Tom :) From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Sent: Fri, 29 July, 2011 9:41:30 Subject: [libreoffice-users] Re: Base record access unacceptably slow Am 29.07.2011 03:22

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Вячеслав Лебедев
-Исходное сообщение- From: Tom Cloyd Sent: Sunday, July 31, 2011 4:40 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow On 07/29/2011 06:55 PM, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-30 Thread Don Myers
-users] Re: Base record access unacceptably slow Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread Andreas Säger
Am 28.07.2011 08:30, Tom Cloyd wrote: As an aside, have you thoughts to share about HSQLDB vs H2? Any good reason to migrate to H2 (a question entirely separate from the db speed question). I'd be interested to hear your thoughts if you have time to share them. The tiny user community of the

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread Tom Davies
-online.de To: users@global.libreoffice.org Sent: Fri, 29 July, 2011 11:30:16 Subject: [libreoffice-users] Re: Base record access unacceptably slow Am 28.07.2011 08:30, Tom Cloyd wrote: As an aside, have you thoughts to share about HSQLDB vs H2? Any good reason to migrate to H2 (a question

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread Andreas Säger
Am 29.07.2011 13:42, Tom Davies wrote: Hi :) Could that community be prevailed upon to join TDF and manage the Base part of the project? Presumably they have knowledge of key players and have a good idea of what needs to be done to improve Base? Regards from Tom :) Be assured that those guys

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread Andreas Säger
Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into office documents.

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread NoOp
On 07/29/2011 01:41 AM, Andreas Säger wrote: Am 29.07.2011 03:22, NoOp wrote: Hit F4 in Writer or Calc, right-clickOpen the dBase Bibliography. All the functionality of a flat (unrelational) dBase connection is there. You can connect, query, edit data through forms and dump any row set into

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread ponsiarceds
. tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side the default Ubuntu one. ( I'm using Ubuntu 10.10 64bit ) It

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread planas
Hi On Fri, 2011-07-29 at 17:55 -0700, ponsiarceds wrote: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm really not on home ground here at all. FWIW, here is a relatively painless way to install an older JRE along side

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread jorge
Hi Thanks you for this tips and to all for Base and data bases tips ! Regards, Jorge Rodríguez El vie, 29-07-2011 a las 17:55 -0700, ponsiarceds escribió: . tomcloyd wrote: , On 07/28/2011 12:53 AM, Tom Cloyd wrote: Ug. This is getting ugly really fast. I'm

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-29 Thread Tom Cloyd
I'll chime in - thanks indeed. I just removed my current sun-java, and installed sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and sun-java6-jre_6.22-0ubuntu1~10.04_all.deb Everything seems to run fine. However, the increase in Base/HYPERSQL speed is only about 25%. Disappointing. This still

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd
Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote: Hallo Andreas, In my view, BASE falling apart would mean LO's death sentence in the long run!

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd
Don, Seems like a reasonable request to me, and I'll up the ante. Where the ^%$ is the management - The Document Foundation - in all this, right now, today? Do they even watch this list? In short, do they give a damn that the only theoretically viable alternative to Access (for ordinary

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
and from who and go get it. Regards from Tom :) From: Tom Cloyd t...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Paul D. Mirowsky
Has anybody suggested that this command should an option when saving when ever records are deleted? On 7/27/2011 12:14 PM, Tom Cloyd wrote: SHUTDOWN COMPACT -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Don C. Myers
Hi, Different ones of us have tried this. It is a Java issue. I keep my database compacted on a regular basis. Thank you for trying to be of assistance. Don On 07/28/2011 12:45 PM, Paul D. Mirowsky wrote: Has anybody suggested that this command should an option when saving when ever

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Andy Brown
Tom Cloyd wrote: much clipped to save space 2. If LO's in trouble with the current sun-Java, so's OO. Where's Apache in this situation? Again, where's *TDF*? Why aren't they and Apache working together on this? Looks rather like a leadership problem, to me. Tom, the other points I can

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Jean-Francois Nifenecker
Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF have announced they would get rid of the java-isms in the code. This implies a major rewrite

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Don C. Myers
Hi Tom, Thank you for your great ideas and suggestions. Starting with Java 1.6.0_24, this problem arose with both OpenOffice Base and LibreOffice Base. The problems were documented on an OpenOffice forum that I searched when the problem first arose. Another alternative would be for

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd
: Thu, 28 July, 2011 17:06:15 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Heinz, I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Tom On 07/28/2011 05:08 AM, Heinrich Stoellinger wrote

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
Cloyd t...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 18:16:57 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow I'm up for it! (Love that quote!) Maybe leaking this issue to the press would get some attention?? Tom C. On 07/28/2011 10:29 AM, Tom

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Cloyd
in and fix it. Regards from Tom :) From: Tom Cloydt...@tomcloyd.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 18:16:57 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow I'm up for it! (Love that quote!) Maybe leaking this issue

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
from Tom :) From: Andy Brown a...@the-martin-byrd.net To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:57:32 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Tom Cloyd wrote: much clipped to save space 2. If LO's

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Tom Davies
as duplicates quite quickly when they are on a roll. Regards from Tom :) From: Paul D. Mirowsky p_mirow...@bentaxna.com To: users@global.libreoffice.org Sent: Thu, 28 July, 2011 17:45:05 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Has

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread planas
Heinrich, On Thu, 2011-07-28 at 08:15 +0200, Heinrich Stoellinger wrote: Hi Tom, Just my - maybe naive - 2 pennies worth of comments: As I mentioned before, I have been using OO/LO for years together with BASE with MySQL (which - also sigh) now belongs to Oracle as well. As a connector to

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Cor Nouws
Hi Tom, Tom Cloyd wrote (28-07-11 18:06) I completely agree. LO without a function Base won't fly. Either TDF recognizes this - by DOING something - or we have our answer. Well, the challenges with base are known. This does not mean that there is an instant solution. However the fast

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread Andreas Säger
Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote: Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work. TDF have announced they would get rid of the

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-28 Thread NoOp
On 07/28/2011 12:50 PM, Andreas Säger wrote: Am 28.07.2011 19:05, Jean-Francois Nifenecker wrote: Hi, Le 28/07/2011 18:10, Heinrich Stoellinger a écrit : In my view LO/OO do NOT require Java, neither on Linux nor on Windows. AFAIK, LO/OOo currently *DO* require Java for Base to simply work.

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-27 Thread Alexander Thurgood
Le 27/07/11 10:16, Tom Cloyd a écrit : Hi Tom, Just to move the record pointer from the first to the last record takes almost exactly 20 seconds. To do a search of the beginning of the main text field for a 6 character string that isn't there (i.e., the engine searches to the very end of

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-27 Thread Tom Cloyd
Don, So, for 6 months, OO (I presume) and now LO (is it that old?) have been promoting a db which doesn't work. I have over 10 full time days invested in this, and I'm watching it fall apart in front of me, apparently irretrievably. I understand LO has NO programmer working on BASE, and with

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-27 Thread Tom Davies
To: users@global.libreoffice.org; Tom Cloyd t...@tomcloyd.com Sent: Wed, 27 July, 2011 17:53:40 Subject: Re: [libreoffice-users] Re: Base record access unacceptably slow Hello, I have been using OpenOffice and now LibreOffice with BASE for a long time. My MySQL database serves a windband and all

Re: [libreoffice-users] Re: Base record access unacceptably slow

2011-07-27 Thread Simon Cropper (The foss Workflow Guides)
On 28/07/11 02:30, Tom Cloyd wrote: 1. Are there any alternative graphic interface tools that even approximate Base's functionality (other than Access)? The last time I looked - a number of weeks ago, I didn't come up with any equivalents. Tom, The GUI is one element but how do you want too

[libreoffice-users] Re: Base record access unacceptably slow

2011-07-27 Thread Andreas Säger
Am 28.07.2011 00:00, Tom Cloyd wrote: This is do not understand. I thought HYPERSQL was the default db engine. You say you're using it to server ANOTHER db? why not access that directly through Base? Am I misunderstanding something (entirely possible)? I found that doing it this way