Re: Preformance Problems URGENT with V.7

Posted in 1999

Obnoxio The Clown — Tue, 21 Sep 1999 21:31:03 BST — source: Informix-list mailing list archive (1991-1998)

From: "Arjo Snijder" <ajsnijder@hetnet.nl> > >Whe have big problems while saving records to the infomix database, it >takes >between the 20 en 40 second before a record has been saved. I realise this might be a challenge, but could you be a little less specific? I thought not. Anyway: 1. Too many indexes. 2. Update statistics. 3. oncheck -cI 4. What else is going on on your server? 5. What *is* your server? 6. Triggers? 7. Enough memory/buffers? 8. onconfig file, please. 9. schema please. 10. update statistics; select tabname, nrows from systables ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com