Re: Performance-Problems with Online

From: newobelix@my-dejanews.com > >Hello, >my colleague and I have to develop an interface, >that substitutes the C-isam-interface which can't >be used with Informix-Online. >With our Interface we make the same functions >(isopen, isstart, ...) available as C-Isam, but >this functions work with esql/c or 4GL, so that >it is possible to connect to the Online-Server. >Everything is working fine, but especially if we >make a "read next" (we don't do a "read previous" >anyway) about 1.3% of the select-statements we're >executing need nearly 1 second to be done. (for >the tests we use allways the same select- >statement). >Is there any possibility to tune the Online- >Server, to execute this statements faster or does >someone have an idea of what we can do otherwise >to solve this problem? Yes. :-) Yes there is a lot you can do to tune OnLine. Response times should be sub second on a singleton select. The behaviour you're seeing leads me to suspect that you haven't done an UPDATE STATISTICS since loading up your test data. To fully tune, we would need: 1. Your hardware config 2. Your $INFORMIXDIR/etc/onconfig file 3. Your database schema 4. Your SQL Since this is clearly new to you, I suggest, without rancour, that you download the manuals from http://www.informix.com/answers and read, in particular, the OnLine Administrator's Guide and the Performance Guide. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com