[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 rob...@familiegrosskopf.de changed: What|Removed |Added Priority|medium |high See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=51976 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #13 from rob...@familiegrosskopf.de 2012-07-11 08:52:00 PDT --- I have tested this with LO 3.6.0.0 Beta 3. It's a horror: Opening of the table last about 70 seconds, Scrolling to the last value 400 seconds. Must be a stopper for the new LO 3.6 - nobody will work with base any more with such a slow version of base. Will make a new bug-report for this. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #12 from ruebezahl 2012-07-09 00:44:46 PDT --- Created attachment 63990 --> https://bugs.freedesktop.org/attachment.cgi?id=63990 result of search -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 rob...@familiegrosskopf.de changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #11 from rob...@familiegrosskopf.de 2012-07-08 08:31:56 PDT --- Tried to open the table under LO 3.3.4 - its as fast as the opening of the exported table in mysql. You can scroll to the last row at once with JRE 1.6.u22. Same JRE and LO 3.5.5.2 - opening of the table needs over 70 seconds and scrolling to the last record over 200 seconds - unusable. Must be a problem between LO 3.5.* and the internal database. It's not the old Java-problem. It seems to be new since 3.5.* -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #10 from rob...@familiegrosskopf.de 2012-07-08 04:23:09 PDT --- I have tried the same table in MySQL. With Base (LO 3.3.4) and the direct connection the data will be shown at once. With Base (LO 3.5.5.2) and the JDBC-Connection it's a little bit slower. I don't know, if this is a problem of the internal HSQLDB. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #9 from rob...@familiegrosskopf.de 2012-07-08 02:06:51 PDT --- Created attachment 63967 --> https://bugs.freedesktop.org/attachment.cgi?id=63967 Try the queries - between 22500 and 25000 rows it's getting slow I have taken the first attachment and tried some queries. When you get a result of more than 22500 rows the queries open very slow. This problem appears with every JRE, also 1.6.u22 I have used before under Linux rpm 32bit. The CPU shows nearly 100%. The cache isn't touched and there is a lot of memory free. I will try the same with the database and a connection to mysql. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 rob...@familiegrosskopf.de changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #8 from rob...@familiegrosskopf.de 2012-07-08 00:49:00 PDT --- Now I have tested it another time with OpenSuSE and the JRE 1.6.29. Seems that it has been fixed in the last month. I don't have any problem with my test-database with 8000 rows and 11 fields. But there are much problems with the added database. Difference between our databases: I have a primary-key "INTEGER", nearly all other fields are "VARCHAR". You have a VARCHAR-field for primarykey. Robert -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 rob...@familiegrosskopf.de changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||rob...@familiegrosskopf.de Ever Confirmed|0 |1 --- Comment #7 from rob...@familiegrosskopf.de 2012-07-07 23:58:25 PDT --- Try this with under Linux with openjdk. It works since 1.6.0.0_b24 as fast as JRE 1.6.22. All other versions after JRE 1.6.22 won't work fast enough - exept for you wont to drink a "cup of java" since you search through your data. Status isn't unconfirmed. Its an old problem. Nevertheless I change the Status to "new". -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 Lionel Elie Mamane changed: What|Removed |Added Blocks||6 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 Lionel Elie Mamane changed: What|Removed |Added CC||sberg...@redhat.com --- Comment #6 from Lionel Elie Mamane 2012-06-27 22:30:30 PDT --- @sbergman: this a resurgence of bug 35023 (which you fixed)? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #5 from Urmas 2012-06-23 08:09:32 PDT --- Same slowness with 100% CPU loading on Windows with JRE 1.6.26 -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #4 from David 2012-06-20 05:14:59 PDT --- My apologies, but it does seem that the bug in #35023 is in relation the same as the one they mention here, though how they can say its resolved is beyond me. I can however confirm that no JDK/JRE since 1.6.22 has solved this problem (And I have downloaded 1.7 recently to test) and whatever happened in the LibreOffice 3.5x code, has significantly changed the Base / Java operation that no JRE can help anymore. I have also downloaded Open Office Org 3.4 and it does share the original bug with base, but JRE 1.6.22 still keeps base running faster on OOo. It is also not an Ubuntu specific bug, as Opensuse 12.1 and 11.3 both share it in their versions of LibreOffice/ OpenOffice. (I am the IT guy for a small company running OpenSuse 11.3 as their OS, and 12.1 on the file/ print server and all these laptops share the same problem when testing Base.) Also, the windows (WIN32) versions do not share this problem, so it seems the bug is specific to the combination of Linux / Java / Base. I tested it on a 1Ghz P3 running Windows XP pro with LibreOffice 3.4 and JRE 1.6.31 and it was significantly faster than my Core 2 duo laptop running LibreOffice 3.5.2 on Mint 13... I have done as you advised (*and thanks for that tip!*), and uploaded the file as an attachment to #51239 (#63259) Regards David On 20/06/2012 12:39, bugzilla-dae...@freedesktop.org wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=51239 > > --- Comment #1 from Lionel Elie Mamane 2012-06-20 03:39:42 > PDT --- > Please take a look at bug 35023; it looks like it is the same one? > > I *guess* you are using embedded HSQLDB, right? Then a trick to make small > examples: > > > In the Tools Menu> SQL. > In the "Command to Execute" area enter "checkpoint defrag". > Click the "Execute" button. > > > (else space of deleted data is not reclaimed). Once it is small enough, you > can > attach the example to the bug instead of external service like RapidShare. > -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #3 from David 2012-06-20 04:26:33 PDT --- My apologies, but it does seem that the bug in #35023 is in relation the same as the one they mention here, though how they can say its resolved is beyond me. I can however confirm that no JDK/JRE since 1.6.22 has solved this problem (And I have downloaded 1.7 recently to test) and whatever happened in the LibreOffice 3.5x code, has significantly changed the Base / Java operation that no JRE can help anymore. I have also downloaded Open Office Org 3.4 and it does share the original bug with base, but JRE 1.6.22 still keeps base running faster on OOo. It is also not an Ubuntu specific bug, as Opensuse 12.1 and 11.3 both share it in their versions of LibreOffice/ OpenOffice. (I am the IT guy for a small company running OpenSuse 11.3 as their OS, and 12.1 on the file/ print server and all these laptops share the same problem when testing Base.) Also, the windows (WIN32) versions do not share this problem, so it seems the bug is specific to the combination of Linux / Java / Base. I tested it on a 1Ghz P3 running Windows XP pro with LibreOffice 3.4 and JRE 1.6.31 and it was significantly faster than my Core 2 duo laptop running LibreOffice 3.5.2 on Mint 13... I have done as you advised (and thanks for that tip!), and uploaded the file as an attachment to #51239 (#63259) -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #2 from David 2012-06-20 03:51:11 PDT --- Created attachment 63257 --> https://bugs.freedesktop.org/attachment.cgi?id=63257 This is the watered down database @ about 5% of size -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 51239] An extremely slow search/browse through a database table
https://bugs.freedesktop.org/show_bug.cgi?id=51239 --- Comment #1 from Lionel Elie Mamane 2012-06-20 03:39:42 PDT --- Please take a look at bug 35023; it looks like it is the same one? I *guess* you are using embedded HSQLDB, right? Then a trick to make small examples: In the Tools Menu > SQL. In the "Command to Execute" area enter "checkpoint defrag". Click the "Execute" button. (else space of deleted data is not reclaimed). Once it is small enough, you can attach the example to the bug instead of external service like RapidShare. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
