Re: [Libreoffice-qa] Very VERY slow Base
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/
Re: [Libreoffice-qa] Very VERY slow Base
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/
[Libreoffice-qa] Very VERY slow Base
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? Regards David Silverwood ___ 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/