Apache OpenOffice (AOO) Bugzilla – Issue 105216
Base slow down to work with hsql and Forms and Reports
Last modified: 2010-03-17 16:30:55 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 Datasets. I Attched an screenshot from the "double open form".
Created attachment 64868 [details] Pictuere that form open twice
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?
Created attachment 64889 [details] Example tha is so slow
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.)
I could confirm it on a DEV300_m59. Grabbing.
Fixed in cws dba32h.
Please verify. Thanks.
verified in cws
Checked w/ OOO320m_2, Ubuntu 9.04 - no slow down, in fact a mild speedup Will close after a check on XP
close