On Fri, 2006-02-03 at 23:39 +0000, CPHennessy wrote: > On Wed January 25 2006 07:31, Ross Johnson wrote: > > This is my first post to this list and my first project using OOo Forms. > > I apologise for the length of the message ... > > > > Some background: > > I'm converting a database from MS Access to OOo/PostgreSQL. Mostly this > > has gone very well using mdbtools to migrate the database to PostgreSQL > > and using JDBC to connect OOo to PostgreSQL as the data source (using > > PostgreSQL.org's official JDBC3 driver). I'm using OOo V2.0.1, Sun's > > J2SE 1.5 (JRE 5.0), and PostgreSQL 8.1, all running on the same machine > > which is Fedora Core 3 Linux. The machine is Intel X86 2.4GHz, 1Gbyte > > RAM. > > > > Problem: > > 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). > > Hi Ross, > I think that you may want to ask on [email protected] and/or open a bug > report.
Hi CPH, Yes, Andrew Pitonyak kindly forwarded my message to that list almost as soon as I'd posted it and got a response from Frank the following day and filed an issue report (61228), which has been confirmed and assigned. I know everyones working hard on OOo so I'm continuing to chase this one down myself as best I can. Maybe I might get lucky and actually help the cause a little. I've been adding what info I can to the issue report as I go - eliminating parts of the system mainly. I'm not fluent in C++ but I'm now slowly working my way into the code. I'm currently trying to build OOo and I'm almost there - just a few little prerequisites problems ... then the profiling begins. Meanwhile I'm learning lots on [EMAIL PROTECTED] Cheers. Ross --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
