Re: dbschema

Steve Proctor wrote: > > Hi, > > iv'e got a customer who is upgrading (?) from informix SE 4.10 to SE > 5.05. They have noticed that a dbschema of a large table that was > instantanious under SE 4.10 now takes several minutes under SE 5.05. > > The large the number of rows in the table, the longer the response > from dbschema. I cannot find any mention in the release notices of > any modifications to dbschema, has any one else found this problem ? > is there a resolution to it ? is it indicative of any other speed > related problems that may occur ? > > Thanks for your responses. > > Steve Proctor Hi Steve, I didn't notice the problem, but it must take longer to run the dbschema on 5.05. There are more system tables inside the 5.05 dictionary, i.e. trigger/procedure and constraint tables. Even if you do not have defined any of these features, Informix has to look for this informations. Therefore it cannot be faster than in earlier versions. But I cannot imagine that there's a relation between the dbschema execution time and the number of rows in a "non-system table". Bye Stefan Weideneder