[Libreoffice-bugs] [Bug 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Michael Meeks  changed:

   What|Removed |Added

 Depends on|53473   |

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

tommy27  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #45 from tommy27  ---
I confirm the improvement on Windows with 32 and 64 machines.

..
Win7 Pro 64bit  / Intel Core i7 @3.07 GHz  /  4 GB RAM
LO 4.1.1  |  open table: 2 seconds  |  last record: 7 seconds
..
WinXP Home SP3  32bit / Pentium 4 @3.00 GHz  /  2 GB RAM
LO 4.1.1  |  open table: 5 seconds  |  last record: 22 seconds
..

the 32bit machine is much slower but it's a PC from 2006 so you cannot pretend
too much from it

since the bug report was about "extremely slow search/browse" I'm gonna mark
this as RESOLVED WORKSFORME because the time needed is now acceptable

maybe we could open a follow-up report about the performance gap still existing
between 4.1.1 and 3.4.4 which was even faster.

anyway much of the performance regression seems gone now.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #44 from rob...@familiegrosskopf.de ---
(In reply to comment #43)
> @Robert
> I have an old WinXP 32bit machine (2006) where I could test and record
> performance. however I'm not very familiar with Base...
> 
> could please tell me step-by-step instructions how to load and browse that
> database?

Take this database: https://bugs.freedesktop.org/attachment.cgi?id=63257
Go to "Tables" on the left.
One table appears: "Sales Invoices".
Click on the table. The time between the click and the moment the whole data
you could see are loaded is the time for opening the table. When I do this with
some older versions of LO I could see how the rows were shown step by step to
the bottom of the screen. It lasts more than 4 seconds. When I test it with my
system now it's under 2 seconds.
On the bottom of the table is a button for going to the last record (fourth
button from the left). Click on this button and start the stop watch. When it
has been finished stop the stop watch. You could see the finishing when the
cursor has gone to row 30 859. This is the time to go to the last record. Here
I got more than 1 minute in the past, but only 5 seconds now. OK, has been
better in 3.4.4 (2,5 seconds) but is now very much better than before in LO
4.0.3.3 (I have tested this now with my actual machine; ca. 25 seconds)

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #43 from tommy27  ---
@Robert
I have an old WinXP 32bit machine (2006) where I could test and record
performance. however I'm not very familiar with Base...

could please tell me step-by-step instructions how to load and browse that
database?

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #42 from rob...@familiegrosskopf.de ---
(In reply to comment #41)
> 
> nice test, robert. what about current 4.1.1.2 release? 
> can you reproduce test on the same machine and see if the performance is
> improved or not?

Have just tested it with 4.1.2.1, but not the same machine (too many problems
with tho old - bought a new and installed rpm-64 bit instead of rpm-32 bit
Linux).

5 Seconds to browse to the end of the table with over 3 rows. Couldn't be
only the changing of the system (it's now a Intel Core i3-3220 with 4 GB-RAM in
a so called "Mini-PC").
Don#t know, if the bug has also gone for 32-bit system. But for me it works
now.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

tommy27  changed:

   What|Removed |Added

 CC||ba...@quipo.it

--- Comment #41 from tommy27  ---
(In reply to comment #40)
> Here is a new test, asked for in
> https://bugs.freedesktop.org/show_bug.cgi?id=51239.
> I have started the example-database "Timbabase" with 3 rows in four
> different LO-versions an Linux 32bit rpm-system:
> LO 3.4.4  |  open table: 2 seconds  |  last record: 2,5 seconds
> (This is nearly identical to all LO-Versions included LO 3.5.0 rc1 -
> remember, that LO 3.4.5 is a release after 3.5.0 rc1; it's extremely slow)
> LO 3.5.4  |  open table: 4 seconds  |  last record: 3 minutes, 40 seconds
> LO 3.5.7  |  open table: 4,4 seconds  |  last record: 5 minutes, 35 seconds
> LO 4.0.3.3  |  open table: 4,8 seconds  |  last record: 1 minute, 15 seconds
> 
> So LO 4.0.3.3 is faster than all versions since LO 3.5.0 rc1; but it's 30
> times slower than LO 3.4.4.

nice test, robert. what about current 4.1.1.2 release? 
can you reproduce test on the same machine and see if the performance is
improved or not?

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #40 from rob...@familiegrosskopf.de ---
Here is a new test, asked for in
https://bugs.freedesktop.org/show_bug.cgi?id=51239.
I have started the example-database "Timbabase" with 3 rows in four
different LO-versions an Linux 32bit rpm-system:
LO 3.4.4  |  open table: 2 seconds  |  last record: 2,5 seconds
(This is nearly identical to all LO-Versions included LO 3.5.0 rc1 - remember,
that LO 3.4.5 is a release after 3.5.0 rc1; it's extremely slow)
LO 3.5.4  |  open table: 4 seconds  |  last record: 3 minutes, 40 seconds
LO 3.5.7  |  open table: 4,4 seconds  |  last record: 5 minutes, 35 seconds
LO 4.0.3.3  |  open table: 4,8 seconds  |  last record: 1 minute, 15 seconds

So LO 4.0.3.3 is faster than all versions since LO 3.5.0 rc1; but it's 30 times
slower than LO 3.4.4.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #39 from Lionel Elie Mamane  ---
(In reply to comment #37)
> The cause of this issue was recently analysed. See bug 5 comment 3 and
> follow-ups.

No, what is discussed there is bug 51976. This bug is supposed to be about
another slowdown (but it is extremely hard to separate different slowdowns of
the same operation in testing/discussion).

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Joel Madero  changed:

   What|Removed |Added

 CC||jmadero@gmail.com
 Blocks|37361   |

--- Comment #38 from Joel Madero  ---
As the bug is in NEEDINFO status & the 3.5 MAB bug tracker is being closed I am
going to remove this from the 3.5 MAB. 

@Lionel - if we can put this back in NEW status (all info is there), can you
open the bug back up as NEW and then if you feel like it belongs on 3.6 MAB, go
ahead and make it a blocker for 6 :) Thanks!

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #37 from Fred Toussi  ---
The cause of this issue was recently analysed. See bug 5 comment 3 and
follow-ups.

In summary, navigation on large tables is slow with the embedded HSQLDB
(version 1.8.0) but much faster with the external HSQLDB version 2.2.x which
has query optimisations not available with the older version and performs the
work in much less time. A development version of 2.3.0 has also been tested
with larger embedded databases and shows the improved performance.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #36 from fred  ---
OK. With embedded config, the time taken is 50 seconds. Looks like problem not
solved on the Mac platform after all.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #35 from rob...@familiegrosskopf.de ---
(In reply to comment #34)
> Using LO Version 4.0.0.3 with the test table (DB name: 'timbabase') of
> 30,000+ rows, and connecting as a 'split' DB under HSQLDB v.2.2.8, the time
> to move to the last record is about 8 seconds! So the problem looks like its
> fixed (at least on the Mac platform -  I'm using Mac OS X 10.6 with Java(TM)
> SE Runtime Environment (build 1.6.0_39).

Could you please test with the embedded HSQLDB?
Title of this bug: "An extremely slow search/browse table in embedded HSQLDB."
External database-connections aren't the problem of this bug.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #34 from fred  ---
Using LO Version 4.0.0.3 with the test table (DB name: 'timbabase') of 30,000+
rows, and connecting as a 'split' DB under HSQLDB v.2.2.8, the time to move to
the last record is about 8 seconds! So the problem looks like its fixed (at
least on the Mac platform -  I'm using Mac OS X 10.6 with Java(TM) SE Runtime
Environment (build 1.6.0_39).

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #33 from rob...@familiegrosskopf.de ---
https://bugs.freedesktop.org/attachment.cgi?id=72523 is too small to show the
slow browsing through the table. I have just tested again with timbabase.odb
(https://bugs.freedesktop.org/attachment.cgi?id=63257) and LO 4.0.0.3, OpenSuSE
11.4 32bit rpm. Browsing to last record: 1 minute and 20 seconds.

The problem does still exist. Faster than in 3.5 (since 3.5.0 rc2) and also
faster than 3.6.0 (double and more slow than 3.5.0 rc2) - but much slower than
3.4.4 or 3.3.4, which both need some seconds.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #32 from rob...@familiegrosskopf.de ---
Where do you get this new version. When I have had a look at
http://dev-builds.libreoffice.org/daily/libreoffice-4-0/Linux-x86_10-Release-Configuration/
the newest version is from 29.12.2012
- and this version is as slow as written before in my system. (Linux 32bit rpm)

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #31 from Lionel Elie Mamane  ---
(In reply to comment #29)

> just by the way. one thing came up while testing with forms:
> setting the list length within the preload-trigger did not work (within LO
> 4):
> Sub PreOpenList( event as Object )
>event.Source.FetchSize = 300
> End Sub

Could you please put this in a new bug, attach a reproduction example and put
me in CC? Thanks.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #30 from Julien Nabet  ---
Reto: about what's a mimetype see
http://en.wikipedia.org/wiki/Internet_media_type
I know what odb and other odf files are in fact zip but if you attach odb, it's
better to put mimetype of odb.

On pc Debian x86-64 with master sources updated today, scrolling to last record
is quite fast: less than 2-3 seconds for me on i5, 6GB

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #29 from Reto Diener  ---
Thanks for the quick answers and the link!

Meantime I have tested with the prerelease LO 4 beta 2 (Windows)

Indeed, the bug seems (almost) gone!
Loading AND scrolling to last record now runs quite fast. both about the same
time (1-2s) [scrolling took at least 40s before]

just by the way. one thing came up while testing with forms:
setting the list length within the preload-trigger did not work (within LO 4):
Sub PreOpenList( event as Object )
   event.Source.FetchSize = 300
End Sub

What you mean with 'Fix mimetype'

Regards
Reto

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Julien Nabet  changed:

   What|Removed |Added

  Attachment #72523|application/x-zip-compresse |application/vnd.oasis.opend
  mime type|d   |ocument.database

--- Comment #28 from Julien Nabet  ---
Comment on attachment 72523
  --> https://bugs.freedesktop.org/attachment.cgi?id=72523
Small database (hsqldb) with one table to show performance degradation

Fix mimetype

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #27 from rob...@familiegrosskopf.de ---
(In reply to comment #26)
> please repeat the testing with libreoffice 4 beta 2:
> https://www.libreoffice.org/download/pre-releases/
> 
> I had the same problem and in that version something has changed that made
> it work. 

Can't confirm, that it is working now with Version 4.0.0.0.beta2+ from
2012-12-28_12:46:28 (latest Version).
It isn't necessary to attach another file. All tests for this bug were made
with
https://bugs.freedesktop.org/attachment.cgi?id=63257
It last over 1 minute to reach the last row. Better than before, but not really
the 3 seconds, that LO 3.3.4 needs for this.
I tested this with OpenSuSE 11.4, 32bit rpm.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #26 from pasqual milvaques  ---
please repeat the testing with libreoffice 4 beta 2:
https://www.libreoffice.org/download/pre-releases/

I had the same problem and in that version something has changed that made it
work. I hope that the problem is really solved and the fix backported to the
3.6 series for 3.6.5

best regards

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #25 from Reto Diener  ---
It seems I have precisely the same problem within my environment:
LibreOffice 3.6.4.3 on Windows XP (Intel Core i3, 2.5GHz, 4GB Memory)

I tested with several version of Java6 RT 6.06, 6.022, 6.038 (latest). No
difference at all.

All ended with the same result:
Loading of a simple table containing about 4700 records goes quick (1s)
(about 70 records are loaded) 
Loading of the rest of the table (jumping to the last record) goes terribly
slow (45s)!

See attached test-db (with embedded HSQL 1.8)

I tested additionally with a MySQL-DB via JDBC (from Oracle). Again: NO EFFECT.
Same performance problem!

Inspecting the task-monitor: 
One of the 4 cores goes up to 100% (so 25% totally). There is no IO-activity
for at least 30 seconds (only memory consumption is slowly increasing).

By the way: Switching to Ubuntu 12.04 LT (same hardware) with latest
LibreOffice installed: Again, the same problem

Would be very cool to have a fix for that. Really!

Many thanks
Reto Diener, Switzerland

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #24 from Reto Diener  ---
Created attachment 72523
  --> https://bugs.freedesktop.org/attachment.cgi?id=72523&action=edit
Small database (hsqldb) with one table to show performance degradation

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #23 from fred  ---
(In reply to comment #21)
> And moving to the last row of the repro file (30,849 rows) using Apache OO
> 3.4.1 (on Mac OS X.6) takes 4 secs (if that is relevant). It takes about 1
> min 58 secs under LO Version 3.6.4.3 (Build ID: 2ef5aff) on the same machine.

I forgot to say the version of JRE I have installed for the above tests is
1.6.0_37 (I think that version is provided by Apple). Also, under AOO, the
repro file table ("Sales_Invoices_ID") opens almost instantly.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #22 from rob...@familiegrosskopf.de ---
(In reply to comment #21)
> And moving to the last row of the repro file (30,849 rows) using Apache OO
> 3.4.1 (on Mac OS X.6) takes 4 secs (if that is relevant). It takes about 1
> min 58 secs under LO Version 3.6.4.3 (Build ID: 2ef5aff) on the same machine.

Interesting for developers: AOO 3.4.1 has the same bug as LO 3.3.4: If I start
it (under Linux rpm, 32bit) with jre 1.6.0_22, it's running as fast as LO 3.3.4
(only some seconds moving to last rows). But when I use another jre (tried it
with 1.6.0_29) it lasts 18 seconds only to open the table, and 4 minutes and 50
seconds to move to last row.

The bad browsing to last record seems to be introduced to LO, when there was
something changed to let LO (under Linux) work with other jre as only jre
1.6.0_22.
https://bugs.freedesktop.org/show_bug.cgi?id=35023

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #21 from fred  ---
And moving to the last row of the repro file (30,849 rows) using Apache OO
3.4.1 (on Mac OS X.6) takes 4 secs (if that is relevant). It takes about 1 min
58 secs under LO Version 3.6.4.3 (Build ID: 2ef5aff) on the same machine.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #20 from rob...@familiegrosskopf.de ---
I have tested now with LO 4.0.0.0 beta from 2012/12/15
Time to browse to the end of the table with over 3 rows is now 1:20
minutes. Much better than nearly 6:00 minutes I have tested for LO 3.6.* here:
https://bugs.freedesktop.org/show_bug.cgi?id=51976#c16

But when I start my LO 3.3.4, this version needs only 3 seconds to reach the
last row.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #19 from Alex Thurgood  ---
(In reply to comment #18)
> Tested also on Mint 13 KDE 32bit :
> 
> JDK 1.6.024
> 
> Time to completion : 2 min 28 secs
> 
> then with JDK 1.7 :
> 
> Time to completion : 1.7.09
> 
> so at least on my 32bit builds, this is much better :-)
> 
> 
> Alex

Oops, should correct that :

JDK 1.7.09
Time to completion : 2 min 30 secs

Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #18 from Alex Thurgood  ---
Tested also on Mint 13 KDE 32bit :

JDK 1.6.024

Time to completion : 2 min 28 secs

then with JDK 1.7 :

Time to completion : 1.7.09

so at least on my 32bit builds, this is much better :-)


Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #17 from Alex Thurgood  ---
Tested with :

Version 4.1.0.0.alpha0+ (Build ID: 7f78980ea260999c88878e362a4d6948d41ddbd)

Pear Linux 32bit

JDK 1.6-024

Time to completion : ca. 2.5 - 3 minutes


Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #16 from Lionel Elie Mamane  ---
(In reply to comment #12)
> On my ubuntu-natty (11.04) 32-bit,
> I timed how long it took to move to the last row of attachment 63257
> [details]
> in two local builds from master:

> (*) commit bd9c451, fetched 2012-12-04 around 17:20 UCT, lacks
> Lionel's patch, and it took 335 seconds to move to the last row.

> (*) commit 8450a99, fetched 2012-12-08 around 02:10 UTC, includes
> Lionel's patch, and it took 465 seconds to move the last row.

Ow. Your test says it is actually *slower* now. Darn. That's dispiriting.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #15 from Lionel Elie Mamane  ---
The Java installation to use can be chosen from within LibreOffice:

 Menu Tools / Options / LibreOffice / Java

Choose one, click "OK", you'll have to restart LibreOffice for it to be taken
into account.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #14 from Terrence Enger  ---
Thank you, Julien.  That reminds that the build told me what version
of java it is using...
checking whether to build with Java support... yes
checking for java... /usr/bin/java
checking the installed JDK... checked (JDK 1.6.0_24)
checking for target Java bytecode version... 1.6
checking for javac... /usr/bin/javac

That is--no surprise--the default version.  `java -version` shows
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.5)
(6b24-1.11.5-0ubuntu1~11.04.1)
OpenJDK Client VM (build 20.0-b12, mixed mode, sharing)

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #13 from Julien Nabet  ---
Terrence:
I don't know how to force LO to use a specific javac during building or java
during running but "update-alternatives" command may help you.

In brief, you can choose which javac and java to use, in root (or by prefixing
the command with sudo)
update-alternatives --config javac
update-alternatives --config java

If you don't compile the sources, you just have to choose java part I think.

In details:
See http://doc.ubuntu-fr.org/java

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Terrence Enger  changed:

   What|Removed |Added

 CC||lo_b...@iseries-guru.com

--- Comment #12 from Terrence Enger  ---
On my ubuntu-natty (11.04) 32-bit, output from `

 dpkg-query --list '*jre*' | grep '^i'

shows

ii  default-jre 1:1.6-40ubuntu1   Standard Java or
Java compatible Runtime
ii  default-jre-headless1:1.6-40ubuntu1   Standard Java or
Java compatible Runtime (headless)
ii  gcj-4.4-jre-headless4.4.5-15ubuntu3   Java runtime
environment using GIJ/classpath (headless version)
ii  gcj-4.4-jre-lib 4.4.5-15ubuntu3   Java runtime
library for use with gcj (jar files)
ii  gcj-4.5-jre 4.5.2-8ubuntu1Java runtime
environment using GIJ/classpath
ii  gcj-4.5-jre-headless4.5.2-8ubuntu1Java runtime
environment using GIJ/classpath (headless version)
ii  gcj-4.5-jre-lib 4.5.2-8ubuntu1Java runtime
library for use with gcj (jar files)
ii  gcj-jre 4:4.5.2-1ubuntu3  Java runtime
environment using GIJ/classpath
ii  gcj-jre-headless4:4.5.2-1ubuntu3  Java runtime
environment using GIJ/classpath (headless version)
ii  icedtea-6-jre-cacao 6b24-1.11.5-0ubuntu1~11.04.1  Alternative JVM
for OpenJDK, using Cacao
ii  icedtea-6-jre-jamvm 6b24-1.11.5-0ubuntu1~11.04.1  Alternative JVM
for OpenJDK, using JamVM
ii  openjdk-6-jre   6b24-1.11.5-0ubuntu1~11.04.1  OpenJDK Java
runtime, using Hotspot JIT
ii  openjdk-6-jre-headless  6b24-1.11.5-0ubuntu1~11.04.1  OpenJDK Java
runtime, using Hotspot JIT (headless)
ii  openjdk-6-jre-lib   6b24-1.11.5-0ubuntu1~11.04.1  OpenJDK Java
runtime (architecture independent libraries)

I do not know how to tell what my LibreOffice is using.


My configuration parameters are
--enable-dbgutil
--enable-crashdump
--disable-build-mozilla
--without-system-postgresql
--without-myspell-dicts
--without-help
--with-extra-buildid


I timed how long it took to move to the last row of attachment 63257
in two local builds from master:

(*) commit bd9c451, fetched 2012-12-04 around 17:20 UCT, lacks
Lionel's patch, and it took 335 seconds to move to the last row.

(*) commit 8450a99, fetched 2012-12-08 around 02:10 UTC, includes
Lionel's patch, and it took 465 seconds to move the last row.


Remember that debug builds can impose an orders-of-magnitude
performance penalty, as I noted in bug 56400 "FILEOPEN and close very
slow on a particular .odt"
.  That was in
Writer, which is differnt of course.


HTH,
Terry.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #11 from Lionel Elie Mamane  ---
(In reply to comment #7)

> I opened the Timbabase.odb file on a 32bit Linux master build :

> Double-clicked to load the table, 4-5 seconds to load the table and display.
> Clicked on the "Go to last record" arrow. 
> After more than 5 minutes of waiting, I gave up and killed the whole
> process. So no significant gain for me.

> JRE version: 6.0_24-b24
> # Java VM: OpenJDK Client VM (20.0-b12 mixed mode, sharing linux-x86 )
> # Derivative: IcedTea6 1.11.5
> # Distribution: Ubuntu 12.04 LTS, package 6b24-1.11.5-0ubuntu1~12.04.1

> LibreOffice Build
> Version 4.1.0.0.alpha0+ (Build ID: 625ce5e92ba1850c841ce591f7bc395243af46a)

That's too old. The important commit (fixing bug 53281) is:


 commit bd60c90f854954aad4361e6de9829e0db2ac2ccc
 Author: Lionel Elie Mamane 
 Date:   Wed Dec 5 18:09:57 2012 +0100

 fdo#53281 Don't cache whole row in KeySet

 This was done for the sake of ODBC,
 but the cost was imposed on all backends.

 The ODBC problems are now solved cleanly (and more efficiently)
 in the SDBC<->ODBC layer.

 Change-Id: Ib8a864da08deaaacc96a379fb72b3b7cbb34598c


Need tests with things newer than that.


(In reply to comment #10)
> 64bit build 
> Version 4.1.0.0.alpha0+ (Build ID: abb1e3352b21d26e2ea00f504162540daa7d69f)

That's also too old to be of a meaning.

> on 64bit Bodhi Linux 2.0 and

> java version "1.7.0_09"
> Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
> Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

> The time to completion drops to 9 minutes - looking better :-)

Maybe the difference comes from the Java version?

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #10 from Alex Thurgood  ---
However, with :

64bit build 
Version 4.1.0.0.alpha0+ (Build ID: abb1e3352b21d26e2ea00f504162540daa7d69f)

on 64bit Bodhi Linux 2.0 and

java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

The time to completion drops to 9 minutes - looking better :-)

Possibly, my 32bit build was made before your change was integrated. Will have
to rebuild it and try again.


Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #9 from Alex Thurgood  ---
Also tested with :

JRE version: 7.0_09-b30
# Java VM: OpenJDK Client VM (23.2-b09 mixed mode, sharing linux-x86 )

I waited this time (coffee break) :

Time to completion : 13 minutes and 30 seconds.

:-/

Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #8 from Alex Thurgood  ---
Additional info :

JRE version: 6.0_24-b24
# Java VM: OpenJDK Client VM (20.0-b12 mixed mode, sharing linux-x86 )
# Derivative: IcedTea6 1.11.5
# Distribution: Ubuntu 12.04 LTS, package 6b24-1.11.5-0ubuntu1~12.04.1

LibreOffice Build
Version 4.1.0.0.alpha0+ (Build ID: 625ce5e92ba1850c841ce591f7bc395243af46a)

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #7 from Alex Thurgood  ---
(In reply to comment #6)
> Need new tests with libreoffice 4.0.beta2 or later.
> 
> Or with a libreoffice-4-0 or master (4.1.alpha) daily build from *after*
> today.
> 
> It should be faster, but is it still significantly slower than before?

Hi Lionel,

I opened the Timbabase.odb file on a 32bit Linux master build :

System:Host: Aspire-X1430 
Kernel: 3.2.0-34-generic i686 (32 bit) Desktop: KDE 4.8.5 Distro: Linux Mint 13
Maya
Machine:   Mobo: Acer model: Aspire X1430
Bios: AMI version: P01-C1 date: 11/16/2011
CPU:   Dual core AMD E-350 APU with Radeon HD Graphics (-MCP-)
cache: 1024 KB flags: (lm nx sse sse2 sse3 sse4a ssse3 svm) 
Clock Speeds: 1: 800.00 MHz 2: 800.00 MHz
Graphics:  Card: Advanced Micro Devices [AMD] nee ATI Wrestler [Radeon HD 6310] 
   X.Org: 1.11.3 drivers: ati,fglrx (unloaded: fbdev,vesa,radeon)
Resolution: 1440x900@59.9hz 



Double-clicked to load the table, 4-5 seconds to load the table and display.
Clicked on the "Go to last record" arrow. 
After more than 5 minutes of waiting, I gave up and killed the whole process.
So no significant gain for me.

Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Lionel Elie Mamane  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #6 from Lionel Elie Mamane  ---
Need new tests with libreoffice 4.0.beta2 or later.

Or with a libreoffice-4-0 or master (4.1.alpha) daily build from *after* today.

It should be faster, but is it still significantly slower than before?

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Lionel Elie Mamane  changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=51976

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Bug 52170 depends on bug 53281, which changed state.

Bug 53281 Summary: A double-plus-more extremely slow search/browse table in 
embedded HSQLDB since 3.5.5/3.6.0.beta
https://bugs.freedesktop.org/show_bug.cgi?id=53281

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Lionel Elie Mamane  changed:

   What|Removed |Added

 Whiteboard||hfmuc2012

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Lionel Elie Mamane  changed:

   What|Removed |Added

 Depends on||53473

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Jochen  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever Confirmed|0   |1

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Lionel Elie Mamane  changed:

   What|Removed |Added

 Depends on||53281

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

Bug 52170 depends on bug 51239, which changed state.

Bug 51239 Summary: A double-plus-more extremely slow search/browse table in 
embedded HSQLDB since 3.5.5/3.6.0.beta
https://bugs.freedesktop.org/show_bug.cgi?id=51239

   What|Old Value   |New Value

 Resolution||FIXED
 Status|ASSIGNED|RESOLVED

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #5 from rob...@familiegrosskopf.de 2012-07-21 10:52:11 PDT ---
(In reply to comment #3)

> Hmm... we need a test comparing 3.3.x with JRE 1.6.22 and 3.5.4 with JRE 
> 1.6.24
> or older. 

Here with JRE 1.6.22, LO 3.3.4 and OpenSuSE 32-bit: 3s!

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #4 from Alex Thurgood  2012-07-20 19:43:30 PDT 
---
(In reply to comment #3)
> 3.5.5 final: 120s
> 3.5.4 rc2 (=final): 120s
> 
> 
> Hmm... we need a test comparing 3.3.x with JRE 1.6.22 and 3.5.4 with JRE 
> 1.6.24
> or older. My "slower on dev tree" thing is probably because it is a debug
> build.

Just for comparison with different JVMs :

Linux Mint 12 64bit, LO 3.4.4 64bit

Jvm 1.6_24
Opens ODB in approx 22 seconds
Goes to end of resultset in 6 min, maxing out processor occupation (noted via
top)

Jvm 1.6_26
Opens ODB in approx 30 seconds 
Goes to end of resultset in 6 min, maxing out processor occupation (noted via
top)

Oracle openJDK 1.7.0
Opens ODB in approx 2 min
Took more than 16 minutes to move to end of resultset, gave up and killed
process, maxed out processor occupation

Alex

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #3 from Lionel Elie Mamane  2012-07-18 08:56:17 
PDT ---
3.5.5 final: 120s
3.5.4 rc2 (=final): 120s


Hmm... we need a test comparing 3.3.x with JRE 1.6.22 and 3.5.4 with JRE 1.6.24
or older. My "slower on dev tree" thing is probably because it is a debug
build.

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #2 from Lionel Elie Mamane  2012-07-18 08:36:40 
PDT ---
3.5.5.rc1 (official packages): 130s

LibreOffice 3.3.4: 300s with OpenJDK 6b24-1.11.1-6, but that's probably because
of bug 35023

-- 
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 52170] An extremely slow search/browse table in embedded HSQLDB

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=52170

--- Comment #1 from Lionel Elie Mamane  2012-07-18 08:22:51 
PDT ---
So, in my development tree, *after* bug 51239 is fixed, it takes more than 350
seconds to move to the last row of the table.

reproduction file: https://bugs.freedesktop.org/attachment.cgi?id=63257

1) Open file in Base, either with 3.5.4 or earlier, or with any tree where bug
51239 is fixed.

2) Click on "tables" in the left part of the window

3) double-click on "Sales Invoices"

4) click on "go to last record" button in the navigation bar on bottom of
window.
Image looks like |>| (a triangle then a vertical bar)


On 3.4.6 (Debian package): 120s

-- 
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