Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

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


Hi :)
We need to attract some devs to this project.  Preferably paid devs because 
there is a bit of a quagmire trying to work out which patches have which 
licences and so which cannot be incorporated into the LGPL and which can.  It 
needs people that work like devs but also people that like to research like 
documenters.  Could we get Wikipedia, Google, RedHat, Cannonical and others to 
stump up some cash for this?  Could TDF itself afford to pay for it?  I think we 
need a couple of full-time paid researchers and a paid dev to start things 
moving.  I think those researchers could move into coding or documentation after 
even perhaps just 3 - 6 months with any luck.  How could we get this going 
forwards before the whole Suite falls over due to the 1 app's failures?  

Regards from
Tom :)





________________________________
From: Heinrich Stoellinger <hc.stoellinger@aon.at>
To: users@global.libreoffice.org; Tom Cloyd <tc@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 the issues related
to such an animal (eg. repertoire, uniforms, members, contacts, concert
programmes, etc., etc.).
Of course my tables are small compared to what I used to see when working
with DB2 at large IBM-customers. "Big" tables might have some 30.000
tuples in them, so just looking for a particular item using a filter
such as "like name*" never takes long.
On the other hand, I have been complaining about problems using the
report writer for serial letters. Conditions based on variables in a
table are not handled correctly in the Linux 3.3.3 version (they seem
th work under Windows!!).
I REALLY depend on BASE not falling behind or on its face altogether.
So I also think that some emphasis should be place on it. Unfortunately
I neither have the knowledge nor the time to devote myself to such an
effort...
Regards from Austria
H. Stoellinger


On Wed, 27 Jul 2011 18:30:46 +0200, Tom Cloyd <tc@tomcloyd.com> wrote:

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 the lack of protest see on the list no one's using it anyway.

I'm baffled by all this. This thing is actually far more stable and
reliable than I ever experienced Access to be when I used it daily for
about 5 years. The interface designer works well. There's just not much
to be distressed by and a lot to like, but...it looks like a dead dog.
This is sad, and perplexing, and ultimately irrational.

For me personally, it's also desperate - or rather *I* am. I'm doing
this thing to support my work with a non-profit educational group
associated with the Wikimedia Foundation (the folks who manage
Wikipedia). I only have so much time, and I've invested a lot in this
project. Now I essentially have little or nothing to show for it, right
when we're working hard against an utterly inflexible deadline.

I see no reason to hope for a fix with Base, and when my record count
doubles again, later this week, it'll take almost 5 minutes to locate a
record that's at the other end of the db, I need an alternative.

Does anyone have any suggestions?

More specifically,

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.

2. How feasible is it simply to use SQL? I never done this, so I have no
idea.

Since I'm reasonable comfortable with Ruby, I'm trying to think of a way
to port this thing to a db engine that has a ruby driver (which HYPERSQL
doesn't - tells us something, doesn't it?), and do it all from a command
line. Painful thought, but better than grinding to a complete halt.

I'm eager to read people's thoughts on all this.

And thanks, Alex and Don, for your response.

Tom



On 07/27/2011 06:34 AM, Don Myers wrote:
I've used base ever since it was first offered. About 6 months ago a
Java update (I'm running Ubuntu 11.04) slowed it down to a pathetic
speed. The latest Java update didn't really help much. I was hoping it
would be fixed that update, or that the LibreOffice folks would find a
solution

On 07/27/2011 07:03 AM, Alexander Thurgood wrote:
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 the table) takes 2 minutes and 5 seconds.
You can imagine how long it takes to locate and update 10 records. This
is the worst performance I've ever seen in a database, period.
Unfortunately, you are not the first, and no doubt the last either, to
report performance issues using the Base with integrated hsqldb. The
problem is not hsqldb, which actually on its own performs quite well,
but the manner in which Base loads everything into memory to be able to
work.

You could try issuing a SHUTDOWN COMPACT command from the Tools>  SQL
dialog, then saving and closing your ODB file before re-opening it
again.

Alex







-- 
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

-- 
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
-- 
Unsubscribe instructions: E-mail to steering-discuss+help@documentfoundation.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.documentfoundation.org/www/steering-discuss/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.