IDS 7.3 and large temp files

Hi, since updating IDS 7.1 to 7.31.UC2-1 (Solaris 2.7) i've got trouble with large temp files on the server. ODBC works well, but using Delphi table-components is quite slow. With IDS 7.1 there have been no problems. Opening a delphi table component produces large temp files on the server, it takes up to 15 minutes to open a single table (for the first user, other connections are rejected or it takes more than 15 minutes). I'm using iconnect 2.5. any ideas? thanks joachim Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Is it possible that the queries that Delphi is generating contain correllated sub-queries? V7.31's sub-query unrolling will convert these into simple joins which should run faster. However, if there is no index to support the join a dynamic hash table or dynamic index will be created which will exhibit the behavior you are experiencing. Get Delphi to reveal the query it posted and run it SET EXPLAIN ON to see what is happening. If this is the case add the missing indexes or update statistics so existing indexes can be used. Art S. Kagel joachim565@my-deja.com wrote: > > Hi, > > since updating IDS 7.1 to 7.31.UC2-1 (Solaris 2.7) i've got trouble with > large temp files on the server. ODBC works well, but using Delphi > table-components is quite slow. With IDS 7.1 there have been no > problems. Opening a delphi table component produces large temp files on > the server, it takes up to 15 minutes to open a single table (for the > first user, other connections are rejected or it takes more than 15 > minutes). > > I'm using iconnect 2.5. > > any ideas? > > thanks > > joachim > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.

there's no problem with subqueries or missing indices. It apears when you open a single flat table using a delphi TABLE-Component. The same data derived with a delphi QUERY-Component with the statement 'select * from tablename' takes less than a second. The whole system was running fine with IDS 7.1, we changed nothing but the IDS version to 7.3 and restored the complete database. anyway, I will try the SET EXPLAIN mode on the server.. but i wonder if there are some new defaults in configuration which cause IDS 7.3 to behave like that. Joachim Herzig In article <37960E88.42CE8466@bloomberg.net>, kagel@bloomberg.net wrote: > Is it possible that the queries that Delphi is generating contain > correllated sub-queries? V7.31's sub-query unrolling will convert > these into simple joins which should run faster. However, if there > is no index to support the join a dynamic hash table or dynamic index > will be created which will exhibit the behavior you are experiencing. > Get Delphi to reveal the query it posted and run it SET EXPLAIN ON to > see what is happening. If this is the case add the missing indexes or > update statistics so existing indexes can be used.> > Art S. Kagel > > joachim565@my-deja.com wrote: > > > > Hi, > > > > since updating IDS 7.1 to 7.31.UC2-1 (Solaris 2.7) i've got trouble with > > large temp files on the server. ODBC works well, but using Delphi > > table-components is quite slow. With IDS 7.1 there have been no > > problems. Opening a delphi table component produces large temp files on > > the server, it takes up to 15 minutes to open a single table (for the > > first user, other connections are rejected or it takes more than 15 > > minutes). > > > > I'm using iconnect 2.5. > > > > any ideas? > > > > thanks > > > > joachim > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't. > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.