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 isn't a good solution.
I'll restore fully updated sun-java, then follow your instructions, as a
temporary fix.
Meanwhile, I working on a solution is not dependent upon a graphical db
at all, using a more primitive approach which I recently used for an
in-memory entity-relationship db/DSL I wrote about a year ago: I write
db output not to an interactive programmed GUI, but to a set of files
which lie open in the jEdit programmers editor. As soon as an output
file is updated (rewritten), jEdit reloads it, so it's available for me
to peruse. I can have far more files open for ready viewing than I can
screens.
If I need to write into something, I use the DSL to say what, and I get
an open file labeled fields, into which I write, or edit, if I'm making
a correction. Returning to the command line, I indicate the file is read
to be read (since I just saved and closed it) and the program receives
the input.
I'll grant you that this is primitive, but it works right well, is far
more flexible, allows me to use my Ruby skills (such as they are), and
frees me from dependance upon someone else's GUI. Why don't I write my
own? I don't have that skill, nor the time to acquire it. I like
"simple", not "shiny", and I just need information, not colors on the
screen, which this surely gives me. And, it can be used with any db engine.
So...that's where I'm going with my db needs. I just cannot afford to
get further invested in the sink-hole that Base is looking like, much as
I really do like the interface, etc. It's too slow, I might be able to
figure out how to have two subforms, but why not TWELVE? With my
approach, no problem.
Something from my library of quotes:
"The most important rule in our development is always to do the simplest
thing that could possibly work. ...Simplicity is the most important
contributor to the ability to make rapid progress." < http://
www.xprogramming.com/Practices/PracSimplest.html >
t.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tom Cloyd / [email protected] / (435) 272-3332
On 07/29/2011 06:55 PM, 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
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
Tools>Options>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.
--
Unsubscribe instructions: E-mail to [email protected]
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
