Hello Ross,
>>One of the tables in the database has a very large number of columns
>>(251) and I've built a single large form in Calc bound to this table.
>>All of the columns in the table are represented by fields in the form.
>>The problem is: it takes several minutes for the form to go active with
>>the first record. If I reduce the number of form fields then it loads
>>much faster, (timing tests below show that the time to load increases
>>"exponentially" with the number of form fields).
Could you also tell the types of controls involved here? You already
mentioned some radio buttons, but what are the others?
There is at least one known heavy performance problem if you have a Calc
document with lots of list boxes (combo boxes probably suffer it, too).
Also, because of some specialities of Calc, it seems that opening a form
in Calc could be about 3 times slower than opening "the same" (with
respect to the controls) form in Writer. Normally, this isn't noticable,
but this to some degree explains why it is *that* slow: Any performance
penalty from the form controls is roughly tripled in Calc.
Both problems are known, though at least for the first I do now know
whether it applies to your case.
In any case, I'd ask you to submit an issue for this, and attach a
sample .odb, plus a script generating the table (structure only, no data
is necessary I assume).
Thanks & Ciao
Frank
PS: When replying, please keep the OOo mailing lists in the queue.
Thanks.
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
