Engine Performance Requirements - Help !
Posted in 1995
Hi All, We are currently developing an Informix 4GL application for one of our customers. We currently run SCO UNIX 3.2.4, Informix SE/4GL/RDS/ID on a 486 server. Although the database has been developed under SE the customer has now specified required data retrieval times and record estimates that we feel are out of SE capabilities. These values are far greater than when the project was started... For example: Database file (example) Record size :280 bytes Est. Records (over 3 years) :75,000 File Size :20MB (approx) Total system users :16 Total database users :8 The customer wants data retrieval time of < 1 sec from queries were data is entered into key indexed fields. eg.select * from <tab_name> where <key_field1> = <value> We are in the process of running tests on SE with files approx 20MB in size. Should we be looking at OnLine and forgetting SE altogether ? Also, has anyone had experience running this size of database on a 486/Pentium server (such as a Compaq ProLiant) ? Does anyone have any idea of the minimum Informix/Server spec. that we should be looking at ? Any suggestions and help would be greatly appreciated Mike/Keith @compsys.demon.co.uk