To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73245 Issue #|73245 Summary|Base 2.1 odbc access to as/400 slower than in 2.0.4 Component|Database access Version|OOo 2.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|tbrenk
------- Additional comments from [EMAIL PROTECTED] Mon Jan 8 04:48:51 -0800 2007 ------- I updated from 2.0.4 to 2.1 and found that the first access to as/400(iseries) databases is much slower than before. OS/400 release is V4R5 ODBC driver is IBM iseries Acces v.10.00.05.00 It happens on different machines and it is repeatable. The reason seems to be that on accessing a library not only SYSTABLES, but also SYSCOLUMNS are read from the system catalog. There are 1001 relevant records in SYSTABLES and 24838 in SYSCOLUMNS. I checked the job protocol (QZDASOINIT job) and found that it had to allocate 15 x 16MB additional storage and the ended with an error message. I don't know if this is a problem of os/400 or the ODBC driver, but it definitly happens with 2.1 and not with 2.0.4. So does anybody know what has been changed in the Base module? Or how to solve the problem? Tilmann Brenk --------------------------------------------------------------------- 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]