Issue 105216 - Base slow down to work with hsql and Forms and Reports
Summary: Base slow down to work with hsql and Forms and Reports
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m59
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 3.2
Assignee: christoph.lukasiak
QA Contact: issues@dba
Depends on:
Blocks: 99999
  Show dependency tree
Reported: 2009-09-20 09:11 UTC by ud
Modified: 2010-03-17 16:30 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Pictuere that form open twice (118.61 KB, image/png)
2009-09-20 09:12 UTC, ud
no flags Details
Example tha is so slow (199.28 KB, application/vnd.sun.xml.base)
2009-09-22 07:24 UTC, ud
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ud 2009-09-20 09:11:51 UTC
If i use an database in DEV300m59 on WinXP with Java 1.6.0_16 it takes more than
3 times longer to work with Base than in 3.1.1.

To excecute an Report in 3.1.1 takes 25 sec, in DEV300m59 the same 
Report takes 1 minute an 45 sec. without anything on the screen. 
After that, it takes 10 sec. to get the Report with only 22 Pages.

To work with a form it's like the same. After double click it opens 
twice, it takes 20 sec where you can see an empty Form.
If you change the dataset, you see first the Mainformdata refresh, 
than the refresh of the first subform data and after that the 
refresh from the second subform data. The main table has only 21 

I Attched an screenshot from the "double open form".
Comment 1 ud 2009-09-20 09:12:55 UTC
Created attachment 64868 [details]
Pictuere that form open twice
Comment 2 Frank Schönheit 2009-09-21 08:20:31 UTC
That sounds like two different problems - care to submit a separate issue for
the forms problem? Also, given the degree of freedom when creating reports, it
is possible that the concrete report which takes so long does something special
- care to attach a bug doc?
Comment 3 ud 2009-09-22 07:24:08 UTC
Created attachment 64889 [details]
Example tha is so slow
Comment 4 ud 2009-09-22 07:25:10 UTC
I attached the document that takes so long in DEV300m59. I used
reportbuilder m58. Please open:

-  rpt "Rezeptbuch" by double click
=> It will take more time to open in 3.2 than in 3.1

-  go to Queries
-  open "qry_Rezeptbuch" by double click
=> It will take more time to open in 3.2 (40 sec.)
   than in 3.1 (10 sec.)
Comment 5 ocke.janssen 2009-09-23 10:42:30 UTC
I could confirm it on a DEV300_m59. Grabbing.
Comment 6 ocke.janssen 2009-09-23 10:51:14 UTC
Fixed in cws dba32h.
Comment 7 ocke.janssen 2009-09-28 11:23:20 UTC
Please verify. Thanks.
Comment 8 christoph.lukasiak 2009-10-07 15:41:05 UTC
verified in cws
Comment 9 drewjensen.inbox 2009-10-25 21:08:21 UTC
Checked w/ OOO320m_2, Ubuntu 9.04 - no slow down, in fact a mild speedup

Will close after a check on XP
Comment 10 christoph.lukasiak 2010-03-17 16:30:55 UTC