To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61228 Issue #:|61228 Summary:|Large forms are very slow to open Component:|Database access Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|rosspjohnson
------- Additional comments from [EMAIL PROTECTED] Fri Jan 27 00:41:37 -0800 2006 ------- The attached .odb file contains tables (no data) defined for the HSQL database-engine (no external connections) and a form with several hundred controls. Opening the form takes 6:50 minutes on my 2.4 GHz/1Gbyte machine. Having data or not seems not to make a difference. Issue # 57150 made getting the form into the .odb package very difficult but it is at least a known issue. Previous tests using the same form in Calc connected via JDBC to a PostgreSQL server took very similar times to open. On that system I progressively cut the form down to yield the following times: Fields Open time Load time Close time 13 2 8.7 0.5 71 37 9.6 3 90 52 10 4.2 191 89 12 9 222 176 12 15.5 328 406 17 46 - Open time is from clicking the Form Design button to “off” and the appearance of the data source authentication dialog. - Load time is from completing authentication to appearance of first record data in form. - Close time is from clicking Form Design button “on” to refresh of frame in design mode. Note that the number of fields given is only the tabable fields (easiest way to count them). The total number of controls, including labels etc, should be approximately double this. If you plot the numbers you can see that the Open times grow exponentially (or is it quadratically?). Similarly for Close times but these are much lower figures overall. Note that the Open times are until OOo shows the data source authentication dialog for the JDBC connection. This suggests to me that these times not related at all to data source connections, or anything beyond that, such as data/meta data access. There are apparently known issues re slowness with certain controls in Calc, and Combo/List boxes as well, however, I don't think these made much difference with this form, which shows the same Open time for Writer (.odb sample) and Calc, for the full form. The form does contain some Combo lists, but I saw no evidence that these are a problem for Open times. These may account for some sluggishness when moving from one record to the next, but that is a separate issue. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]