Hi Tilmann > 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.
With "first access", I assume you mean the first connection to the database? > 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. Do you have changes to find out what information from SYSCOLUMNS is accessed? Alternatively/Additionally, could you switch on ODBC tracing, and search the logs for suspicious (read: happening way too often) calls related to columns? Can you compare the ODBC logs from 2.0.4 and 2.1 > 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. Sounds like a side effect of some other change, however, I cannot imagine which one. All changes I can think of were already in 2.0.4 or before. Please try to find more information about what exactly is accessed in SYSCOLUMNS, as described above. This might help to track when and were this happens, and why. Ciao Frank -- - 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]
