Re: SE performance

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. Unbelievable :-) >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. Insert 'set explain on;' before the 'select'-statement - and show us the result. Any details about your SCO system would be fine to: disks, memory and processor. >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. See above ... >Are there any Unix kernel parameters that we could configure to help with >the reads and writes. Any help would be appreciated. There are more than enough configurable kernel parameters; but tuning the operating system isn't that simple without any detailed 'sar' informations. -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...