Re: [Libreoffice-qa] Very VERY slow Base

2012-06-14 Thread Petr Mladek
Hi,

better late than newer.

On Fri, 2012-06-01 at 13:00 +0200, David wrote:
 I have a Base database that is about 22mb in size with approximately 
 40,000 entries and climbing. I recently upgraded from LibO 3.4.3 to 
 LibO3.5.4 and suddenly my database is really, and I mean really slow. 
 Sifting through 30,000 entries on one table takes up to twenty 
 minutes I uninstalled the new version, returned to the old version 
 and everything is back to normal, however, uninstalled the older version 
 again, reinstalled 3.5 and the problem is back...
 
 Previously all I had to do was link my LibO to Java Runtime 6.22 and 
 keep it there regardless of upgrades in the JRE, but this time it didn't 
 work. You guessed it, I'm running Linux (Mint 9 on a Dell D620 Core 2 
 Duo laptop). I know there is/was a problem in Linux with OpenOff/ LibO 
 and the JRE and Base and the previous workaround was to not upgrade your 
 JRE beyond 6.22. Is there a new workaround?

Could you please open bug in bugzilla and add Lionel and Michael into
CC?

We will need some more information to locate the problem. The best
solution would be if you attach a test database showing the problem. I
am afraid that you could not provide the original database because it
contains sensitive data. Though, you might try to create another
database with random data that has the same behavior.

Another solution is to follow instructions from Lionel and Michael, and
do some profiling yourself.


Best Regards,
Petr

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


Re: [Libreoffice-qa] Very VERY slow Base

2012-06-14 Thread Lionel Elie Mamane
On Thu, Jun 14, 2012 at 09:52:20AM +0200, Petr Mladek wrote:
 On Fri, 2012-06-01 at 13:00 +0200, David wrote:

 I have a Base database that is about 22mb in size with
 approximately 40,000 entries and climbing. I recently upgraded from
 LibO 3.4.3 to LibO3.5.4 and suddenly my database is really, and I
 mean really slow.

I understand this is embedded HSQL. It would be interesting to see if
the performance problem is:

1) With any database system
2) With all Java (JDBC) systems
3) Only with embedded HSQL

-- 
Lionel
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/