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

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 / tc@tomcloyd.com / (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 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