[Libreoffice-bugs] [Bug 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

--- Comment #13 from rob...@familiegrosskopf.de ---
@Rainer
The fastes way to scroll through a table is to jump to last row. You can click
the "last record"-button. Then the CPU-load is 100%. A fast CPU is much faster,
but with my Netbook the last row is reached after 12 minutes.
The opening of the table (step 1) is also affected. Could be, that this is a
special Linux-problem. I can't say, because I have no other operating system.
When I have read your comment I could not explain,
https://bugs.freedesktop.org/show_bug.cgi?id=51239 should be fixed.
There was a comment in this bug, which describes a big difference between the
version LO 3.5.5 and 3.6.0.4:
https://bugs.freedesktop.org/show_bug.cgi?id=51239#c37
I have not tested it with a 3.5.6 or other version of LO, where the bug 51239
should be fixed.
When you have tested it with Win7 and different versions it seems to be a
problem since 3.4, blown up in 3.5 under Win.
When I reported this bug, I have taken the time for different versions: LO
3.3.4, LO 3.5.5.2 and LO 3.6 Beta 3 unter OpenSUSE 11.4. The time to get the
last row with the "last record"-button, grows from LO 3.5.5.2 to LO 3.6 Beta 3
with factor 2. See also https://bugs.freedesktop.org/show_bug.cgi?id=51976#c6

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

--- Comment #12 from Rainer Bielefeld  ---
A "Jump to last record problem" is [Reproducible] with Server Installation of
"LibreOffice 3.6.2.1 rc  English UI/ German Locale [Build-ID:  da8c1e6] on
German WIN7 Home Premium (64bit) 

Steps how to reproduce with attachment 63257 of "Bug 51239 - A double-plus-more
extremely slow search/browse table in embedded HSQLDB since 3.5.5/3.6.0.beta":

1. Open Sample document from LibO Start Center, menu 'File -> Open'
2. In Database Pane select 'Tables'
3. In Tables Pane open "Sales Invoices" with double click
   > Table opens, showing 23 records in Status bar below table
4. Click 'Last Record' button in Table Data bar (?) below table data
   Expected: Shows record 30849 after few moments 
   Actual: needs 2 Minutes or so with high CPU load

Was still ok with 3.3.3:   3s for step 4
Was some worse with 3.4.2: 15s for step 4, but from then |< and >|
   only take 1s or so

With 3.5.1.2:  3 Minutes for Step 4 
   (I did not measure time exactly), from then
   |< and >| still rather slow, takes 1 minute or
so

With 3.5.7.1:  3 Minutes for Step 4,  from then
   |< and >| still rather slow, takes 30s or so  

With 3.6.2.2:  3,25 Minutes for Step 4 
   (I did not measure time exactly), from then
   |< and >| still rather slow, takes 20s or so
   only tested with this version: scrolling with
   scroll slider after step 4 still is a mess,
   always stops after few lines for several 
   seconds after I can continue

@robert:
This bug still needs a lot of information to deserve Status NEW due to
  item 5:
- What exactly do you mean with "scroll"? Using scroll slider, Scroll buttons 
 (for that 400s would be acceptable), Mouse whell? Please describe exactly!
- What is the problem here? Slow Fileopen (not reproducible at all
  for me) or slow scrolling? Please decide and correct the summary!
   item 4!
- All OS affected or definitively only Linux? 
  -- We need a precise step by step 
 instruction with precise time measurement to keep apart different 
 problems all causing slowness problems
  What exactly is the difference to Bug 51239? 
  I wonder whether WIN was affectet there, I only saw Linux and MAC there, and 
  I still see heavy problems with sample document from that bug

@Lionel:
I am afraid that long discussion here will have no good cost-benefit ration,
may be it will be more effective that you narrow town task of the report to any
obvious "all OS) problem and we will see what will happen after a first fix?

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

rob...@familiegrosskopf.de changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #11 from rob...@familiegrosskopf.de ---
The problem still exists under LO 3.6.2.1, OpenSuSE 12.1, 64bit.
I tested with https://bugs.freedesktop.org/attachment.cgi?id=63967 . Opening
the table, try to scroll with the button "last" to the last record and wait ...
wait ... 12 minutes for the 3 rows.
CPU was running with 100%. CPU is Atom(TM) CPU N570 @ 1.66GHz (Netbook).
I set this bug to Status "New".

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

--- Comment #10 from fred  2012-09-02 03:55:21 UTC ---
> > Not sure if this info is relevant now, but FWIW, moving to the end of a 
> > large
> > table (20,000+ records, 25+ columns) on Mac OS X.6 seems to be much worse 
> > with the current LO version:
> > 84 seconds - LO 3.6.0.4
> > 7  seconds - LO 3.5.5
> > 4  seconds - LO 3.4.6

I might also add that I've just tested the same DB as I used to generate the
above timings with Apache OpenOffice.org 3.4.1 and the timing is about 3
seconds!

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Jochen  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #9 from Jochen  2012-08-27 17:56:36 UTC ---
(In reply to comment #6)
> There seems to be two problems:
>  - One that affects LibO 3.5 (and presumably LibO 3.6), which is a factor MANY
> slowness: bug 51239
>  - Another one that affects LibO 3.6, which is a factor 2 slowness: this bug

@Lionel:
The first problem is solved.
The second problem exists still - but what exactly is the problem respectively
what is the reason? Have you any idea?

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

--- Comment #8 from George Nassar  2012-08-27 
17:35:34 UTC ---
>From bug 51239:

(In reply to comment #38)
> Marking as fixed since it is now backported to all relevant branches.
> 
> (In reply to comment #37)
> > Not sure if this info is relevant now, but FWIW, moving to the end of a 
> > large
> > table (20,000+ records, 25+ columns) on Mac OS X.6 seems to be much worse 
> > with
> > the current LO version:
> > 84 seconds - LO 3.6.0.4
> > 7  seconds - LO 3.5.5
> > 4  seconds - LO 3.4.6
> > Note: I'm connecting to the local DB in FILE MODE (using HSQLDB 2.8)
> 
> This is probably bug 51976 (which is not fixed yet).

Didn't want that to be missed over here.

Also, any possibility bug 53281 is a duplicate of this one?

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Bug 51976 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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Lionel Elie Mamane  changed:

   What|Removed |Added

 Depends on||52170

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

 CC||david.burle...@gmx.com

--- Comment #7 from Julien Nabet  2012-07-15 19:57:38 PDT 
---
*** Bug 52121 has been marked as a duplicate of this bug. ***

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

--- Comment #6 from Lionel Elie Mamane  2012-07-12 14:52:42 
UTC ---
(In reply to comment #5)
> Lionel, I think during work on Bug 51239 you also will check the effects from
> here in 3.6, or is there an additional confirmation required?

There seems to be two problems:

 - One that affects LibO 3.5 (and presumably LibO 3.6), which is a factor MANY
slowness: bug 51239
 - Another one that affects LibO 3.6, which is a factor 2 slowness: this bug

So probably the most "critical" of the two is bug 51239 rather than this one.
Maybe we even won't care about this one once 51239 is corrected ;)

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Rainer Bielefeld  changed:

   What|Removed |Added

   Severity|blocker |critical
 CC||LibreOffice@bielefeldundbus
   ||s.de

--- Comment #5 from Rainer Bielefeld  
2012-07-12 14:42:46 PDT ---
Although I understand that this problem here is a disaster for someone working
with Database, this is not a blocker. Compared to Crashes this has much less
severity, and a cost-benefit calculation does not allow to make not available
these
 Bugfixes.

But of course an unusable HSQLDB is serious.

Lionel, I think during work on Bug 51239 you also will check the effects from
here in 3.6, or is there an additional confirmation required?

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Lionel Elie Mamane  changed:

   What|Removed |Added

   Keywords||regression

-- 
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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

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 51976] FILEOPEN: Base embedded HSQLDB even slower than 3.5.5: open / scroll through table

[bugzilla-daemon]

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

Lionel Elie Mamane  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
 Resolution|DUPLICATE   |
 Depends on||51239
Summary|FILEOPEN: Base is horrible  |FILEOPEN: Base embedded
   |slow, when opening ans  |HSQLDB even slower than
   |scrolling throug a table in |3.5.5: open / scroll
   |internal HSQLDB |through table

--- Comment #4 from Lionel Elie Mamane  2012-07-11 12:03:37 
PDT ---
(In reply to comment #3)
> this isn't a duplicate of 
> https://bugs.freedesktop.org/show_bug.cgi?id=51239

> With LO 3.5 you could work - its slow, but not so slow as LO 3.6 Beta 3.

I see; it is even slower. I had not understood that. Then, indeed it is
probably yet another problem that piles up *on* *top* of bug 51239, and needs
its own bug.

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