Ask Your Question
2

Any way to speed up database search? [closed]

asked 2012-02-19 11:57:35 +0200

AnnB gravatar image

updated 2015-10-15 14:58:09 +0200

Alex Kemp gravatar image

I'm searching a small table (150 records of 10 fields) from a form using the "Record Search" dialog and the search seems really slow. My search terms could be in one of two fields, so I am having to use the the "all fields" option instead of "single field". A query finds all records meeting the criteria in a heartbeat, but I have to first modify the query's search criteria which is kind of cumbersome, and once in a while there's something in the record I want to change, which you can't do with query results.

Any tips or ideas?

Thank you!

P.S. I have a dual-boot set up with Ubuntu 11.10 and WinXP on an oldish IBM laptop. I have my database in a DropBox folder. I have Open Office installed on the WinXP partition and when I search the database from there, it's pretty quick. Ubuntu 11.10 installs Libre Office as default, so I'm using that on the Ubuntu partition and that's where I'm having the problem.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 14:57:18.007568

Comments

1

Remember each and every change to your file-system will trigger upload/downloading to/from your Dropbox account. Is Dropbox installed in all versions / environments you mentioned ?

MagicFab gravatar imageMagicFab ( 2012-03-07 01:20:29 +0200 )edit

3 Answers

Sort by » oldest newest most voted
3

answered 2012-03-11 03:45:33 +0200

AnnB gravatar image

I just upgraded to LibreOffice 3.5.0 and the search flies compared to 3.4.whatever! I thought Base was the redheaded step-child of LibreOffice, but they definitely are working on it.

I found instructions for upgrading (3 terminal commands) at http://www.webupd8.org/2012/02/install-to-libreoffice-350-in-ubuntu.html

edit flag offensive delete link more
1

answered 2012-02-24 23:26:41 +0200

bolodya gravatar image

Had the same problem...

it is a bug with java engine, here its live https://bugs.launchpad.net/ubuntu/+source/sun-java6/+bug/724217

for me worked following:

  1. removed sun-java6-bin package (it was buggy 1.6.0.26)

  2. added repository "deb http://ppa.launchpad.net/sun-java-community-team/sun-java6/ubuntu Lucid Main" (Lucid is for ubuntu 10.04)

  3. added package sun-java6-bin again (now it is 1.6.0.21 version)

  4. in LO settings-java selected 1.6.0.21 java engine

now it works fast, and i am happy:)

edit flag offensive delete link more
0

answered 2012-02-20 01:26:49 +0200

JohnD gravatar image

AnnB -- I don't have any solution for you but just wanted to add my experience about this same subject. I have a number of relatively simple databases - using all "normal" default stuff - i.e. nothing special.

Previously using ooO3.3 or LibreOffice 3.4.3 the "all fields" search of an approximately 300 record base file would go very quickly (I also have a fairly new speedy desktop system with Windows 7-64 bit). After some hassle installing the 3.5.0 package (had to cleanout the old 3.4.3 and also reinstall Java) a database record search is very much slower than 3.4.3.

Hope somebody has some ideas for us! Base does not seem to get the same "respect" or attention as the more popular components. :(

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2012-02-19 11:57:35 +0200

Seen: 937 times

Last updated: Mar 11 '12