Base record access unacceptably slow

users
#81

Hi Don
I'm interested to try this!! Where did you find the Download for 1.6.0.0_22. On the Oracle site all I keep getting is 'Error 404 = Page not found' and I can't find it using Synaptic!!??
Thanks

Ian Whitfield.
/
///

#82

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 mixed. My Base has worked perfectly since doing this. Plus, the 1.6.0_22 is only being used for Base, so you have the updated security of the 1.6.0_26 for browsing, etc. One other person who posted used the 1.6.0_21 version in the post and said it was faster than 1.6.0_22. Mine is working perfectly fine though. You only need the jre version and not the jdk, but either will work. If you need more assistance, please let me know.Here is the post:

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.

.
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 definitely sped up my Base table browsing, but then I don't have any
binaries embedded in my tables. It has the bonus of not messing with the
existing JRE

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 (Tools>Options>Java)
5. Exit LO& restart

Instructions:

1.Download jdk-6u21-linux-i586.bin (for i386) or jdk-6u21-linux-x64.bin for
x86_64 from
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR

JRE archive at ORACLE . Save to /tmp
2.run it using: "sh jdk-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 Tools>Options>Java, 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
>>Java& "sudo rm -rf /usr/lib/jvm/jre1.6.0_21/

--
View this message in context: http://nabble.documentfoundation.org/Base-record-access-unacceptably-slow-tp3202820p3211034.html

Sent from the Users mailing list archive at Nabble.com.

Don

#83

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 excellent.

So, I would urge you at least to compare the two. For me ...0_22 was only about 25% faster, which really didn't fix the problem.

Tom

#84

Hi Tom,

I just tried 1.6.0_21 on my main work computer. I can tell very little difference. I will try it on my slowest computer at home tonight. When 1.6.0_22 was the one used in Ubuntu, my Base was fast. I have over 2600 records in it. If I went from the first record to the last, it was almost instantaneous. When 1.6.0_24 came out, it would take usually 20 to 25 seconds. The same held true with 1.6.0_26. When I switched back to 1.6.0_22 for LibreOffice Base on Saturday, I was back to it being about a second to go to the last record. This is a quad core computer (AMD 910 processor) with 8 gigs of ram running Ubuntu 11.04 32 bit. Yes, I know I could try the 64 bit, but I need everything working such as flash. I have some non main line programs which may not work in 64 bit yet. Maybe I will see a difference on a slower machine. So I will try it at home tonight. I certainly don't see a downside to 1.6.0_21.

Don

#85

Ian,

> 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!!!!!!!!!
>
>> sudo cp -a jre1.6.0_21/ /usr/lib/jvm
>
Hi Don
I'm interested to try this!! Where did you find the Download for
1.6.0.0_22. On the Oracle site all I keep getting is 'Error 404 = Page
not found' and I can't find it using Synaptic!!??
Thanks

Ian Whitfield.
/
///

Try using the install ISO, according to Synaptic on Ubuntu 11.04 you can
use the ISO on a CD/DVD as a repository and you might find the an older
version on it.

Also, you might check with Ubuntu or Debian about doing this. I have not
tired this myself.

#86

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 second or two faster.

Don

#87

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 this thread!!! /

He has just replied.......

/Thanks for your mail!

The question is what the Steering Committee should do about this. What I would recommend is that one of the affected users either writes to the Developer Mailing List, or files a bug report.

Is this something that could help?

Florian
--
Florian Effenberger <floeff@documentfoundation.org>
Steering Committee and Founding Member of The Document Foundation
Tel: +49 8341 99660880 | Mobile: +49 151 14424108
Skype: floeff | Twitter/Identi.ca: @floeff /

This is NOT quite the reply I was hoping for. Is it worth passing this onto the Devs Mail List - I have a feeling somebody already did this.

Base is working for me at the moment - sort of!! - but I would LOVE to see it "sorted out"!! I want to try the change to an early version of Java to see if that helps me or not at some time.

Until then it looks as if we are all stuck with Base as it is!!

Ian Whitfield
////

#88

Ian,

On behalf of all Base users, thanks for trying! As you infer, it would have been encouraging to receive a more pro-active reply, especially from a Founder of TDF (and long-time ex-oOo active member). Perhaps it's difficult for him to say much else, if there are very few Base Developers. I guess they 'stayed' with oOo or have moved on to other things. It will be interesting to see if the oOo version fares any better...but that's another story!

Regards,

Tony Royston.

#89

Ian, thank you from me also. When I see the number of people asking questions about Base on this forum it seems there is a lot of interest in having a database. So far the side by side install of the second, older version of Java has been working very well for me.