Issue 81223 - first-time open of a form containing list boxes filled from large table is too slow
Summary: first-time open of a form containing list boxes filled from large table is to...
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2007-09-03 13:02 UTC by Frank Schönheit
Modified: 2008-03-10 13:31 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2007-09-03 13:02:26 UTC 
This is a follow-up of issue 76024. Therein, it was described that forms which
contain list boxes bound to large tables become effectively unusable, since
traveling through the form is incredibly slow.
The performance problem while traveling has been solved with issue 76024,
however, the performance problem when opening the form for the first time persists.

To reproduce:
- open the document attached to issue 76024
(http://www.openoffice.org/nonav/issues/showattachment.cgi/44162/DB_LbxTest01.odb)
- select "Tables" on the left hand side to ensure the database is connected
- switch back to "Forms"
- double-click the form to open it
=> it takes several seconds to open the form. On my system (some Opteron with
   2.2 GHz) alone 6 seconds are spend for filling the list box ...
Comment 1 Frank Schönheit 2007-10-04 21:25:34 UTC 
oops, this should have been 3.x, not 2.x
Comment 2 Frank Schönheit 2007-10-30 15:33:25 UTC 
fixed in CWS dba24b. The complete form now opens in 2 seconds on my machine
(specs above). Better than before, /me thinks.
Comment 3 Frank Schönheit 2007-11-03 15:44:11 UTC 
fs-> msc: please verify in CWS dba24c
Comment 4 marc.neumann 2007-11-12 13:36:41 UTC 
verified in CWS dba24c

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba24c
Comment 5 drewjensen.inbox 2008-03-10 13:31:26 UTC 
Tested w/ xp and build m_10

closing