Base record access unacceptably slow

David_Nelson1 · July 30, 2011, 9:25am

Hi,

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
SC's twice-weekly call conferences and raising the issue there. At all
the confcalls I've attended, there has almost never been a member of
the user community there to raise questions, yet that was one of the
central things that the confcalls were designed to cater to. The SC
people are very approachable and eager to listen to people, so you
will find interested ears. You can participate in the calls via phone
or Skype (Skype has always worked for me). Details are here:

http://wiki.documentfoundation.org/TDF/Steering_Committee_Meetings#Dial-in_Details

Like you guys, I'm very keen to see Base well-maintained. There's a
confcall today, Saturday, July 30, and I'll raise the question. If
others do the same, it will add weight to the issue...

Tom_Davies · July 30, 2011, 12:42pm

Hi
+1
I'm sure the documentation team would appreciate your input on building up a
guide for Base. It's a major challenge tho!
Regards from
Tom

Don_C_Myers · July 30, 2011, 5:38pm

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 was I used the 1.6.0_22 version since I knew it worked well.

Thank you again so much!!!!!!!!!

tomcloyd · July 30, 2011, 5:51pm

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 matter of joining a call, well, I can do that, and I'll have no problem with articulating my concerns re: Base.

T.

Don_C_Myers · July 30, 2011, 6:51pm

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.

jfn · July 30, 2011, 9:07pm

Could you elaborate, please?

If I remove Java, can I open the Base module and create a query in design mode? I happen to think I can't but I might be mistaken.

Tom_Davies · July 31, 2011, 12:30am

Hi
The main thing is that you found a way to solve your current problem.
Congrats and regards from
Tom

tomcloyd · July 31, 2011, 12:40am

OK, NOW I'm blown away. I had jdk v.22 (from Ubuntu archives) installed as an attempted improvement, and got about a 25% increase in speed. Running now with v. 21 Base is unbelievably snappy and crisp. I've NEVER had it perform like this for me. THIS is exactly what it needs to be. Waaaay better than v. 22.

So, dammit, what will it take to get this fixed, I'm wondering...? I'll follow through with that Steering committee phone call business, but if the problem's java, then Oracle has to fix it. Well, this is quite a bit above my pay grade.

What a fascinating thread this has been. Thanks to all.

T.
Tom Cloyd, MS MA
tc@tomcloyd.com
(435) 272-3332
St. George/Cedar City, Utah

Tom_Davies · July 31, 2011, 12:41am

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 alternatives on the market for people that really need
a database. To move forwards Base needs a serious commitment and a strong
vision of where it wants to get to. If we cut it loose then LibreOffice as a
whole is freed from a lot of dependencies and stuff that the other apps don't
need. So, lets just drop Base.

Regards from
Tom

tomcloyd · July 31, 2011, 12:50am

What I like about this idea is that it frees it up to be picked up by anyone who wants to take it and run with it, and THAT just might work.

I do fear for what it might do with people who need an integrated solution.

t.

Tom_Davies · July 31, 2011, 12:50am

Hi
Phew. Good timing! Have you signed up for steering-discus or do you know the
time of the call and how to join in? It's so late where i am that it's tomorrow
already.

Regards from
Tom

user220 · July 31, 2011, 1:42am

-----Исходное сообщение-----

Don_C_Myers · July 31, 2011, 2:28am

My first database was a dos version. I then moved to Microsoft Office and bought Access to add to it. After a few years I got tired of paying Microsoft prices and got Word Perfect Office Pro which included Paradox. It worked very well. Once Open Office came out, I figured that would ultimately be the end of Word Perfect, so I moved to it, but kept the Word Perfect Suite because I needed a database which was not initially included in OpenOffice. I was delighted when OpenOffice added base, and converted my database from Paradox to Base. My needs are relatively basic for a database. It is mainly for keeping records and also mail merge with LibreOffice writer. I've never had any issues with mail merge. In the back of my mind I really wanted to move to Linux and knew that time would happen sometime, so I tried to have as many programs cross compatible as possible. Almost 2 1/2 years ago I began my Linux journey. I chose Ubuntu because I figured it had the largest user base, and therefore if I had a problem somebody else also probably had the same problem. I don't have time to play with the different flavors of Linux to give them a try, so as long as Ubuntu does the job, I will stick with it. With Open Office having a full suite for Window and Linux, it made the move to Ubuntu almost painless for the OpenOffice programs including Base. I do not know if it is best for Base to stay with LibreOffice or not, but it was a tremendous help to me to have everything all together.

Don

Regina · July 31, 2011, 9:12am

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 alternatives on the market for people that really need
a database. To move forwards Base needs a serious commitment and a strong
vision of where it wants to get to. If we cut it loose then LibreOffice as a
whole is freed from a lot of dependencies and stuff that the other apps don't
need. So, lets just drop Base.

please use a new thread for such a far reaching proposal. And I think, discuss@documentfoundation.org would be more suitable place.

I'm strongly against the proposal, but let us discuss it in a new thread.

Kind regards
Regina

Ian_Whitfield · July 31, 2011, 10:48am

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 the right person.

I have sent him full details of this thread.

Let's hope we get some proper feedback from TDF!!

Ian Whitfield.
////

soumalya_ray · July 31, 2011, 11:53am

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

aon.913450908 · July 31, 2011, 1:08pm

Hello,

Villeroy · July 31, 2011, 3:24pm

Am 30.07.2011 23:07, Jean-Francois Nifenecker wrote:

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 open the Base module and create a query in
design mode? I happen to think I can't but I might be mistaken.

Stop thinking. Start trying. It takes 15 seconds.

1) There is a completely useless query wizard. This is the only query generator depending on Java.

2) There is an almost useless query designer which supports baby SQL only. You can learn that level of SQL for all databases within a day and use 3 with more features and less errors:
3) The SQL editor knows 2 modes:
3a) The "parsed mode" which works well in most cases and which may be viewed in the design view (which may destroy your valid SQL then).
3b) Direct SQL which always works properly when handled by a mature RDBMS such as HSQLDB. Unfortunately, Base makes these row sets read-only and parameter queries don't work.

Villeroy · July 31, 2011, 3:31pm

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 no serial letters nor bibliographic features without this type of connectivity.
All of my spreadsheets would be empty without Base. I import csv and other database row sets entirely through Base.

Nevertheless I aggree that the idiotic nonsense they added since OOo 2.0 should be removed. There is almost no demand for database development within this office suite.
MS Access is a multi-million Dollar project which can not be imitated by a zip container and some ridiculous wizards.

tomcloyd · July 31, 2011, 4:18pm

Thank you Ian. Much appreciated. Hope it has an effect.

t.