Re: SE performance

Just a thought - did you remember to UPDATE STATISTICS after you loaded the data? Ian michelle Attaya Kelo wrote: > > We are running Informix SE 7.1 on Sco Unix 5.0. We have recently ported > to SE from Online and are experiencing a large degradation in > performance. > > One problem is querying a table which has about 23000 rows using a simple > select statement to retreive a single row. > ex > select * from ecr_tab > where lin = "XXXXXX" > and index = "00";> > The lin, and index are the keys for the ecr_tab and are indexed. > > Another problem is writing a group of rows to the database. The rows are > put into a insert cursor before the tables are updated. I takes quite a > long time just to read about 2000 rows into the database. > > Are there any Unix kernel parameters that we could configure to help with > the reads and writes. Any help would be appreciated. > > responses to : mattaya@richmond.infi.net > thanks