SE- Read performance problems

Hi, Do you know any configuration parameters that improve performance for Informix SE SELECT/FETCH operations ? (I use ESQLC under Solaris7 x86) Can i increase buffers ? My configuration "setlitcp" is important for performance ? Thank you Liliano Sent via Deja.com http://www.deja.com/ Before you buy.

There really isn't much you can do to improve performance on SE. There aren't any buffers like online has. SE depends solely on the OS and hardware for performance, so you might check on getting faster drives, or ask you SA about increasing logical buffers. In article <8h8996$hm4$1@nnrp1.deja.com>, liliano@my-deja.com wrote: > Hi, > Do you know any configuration parameters that improve performance for > Informix SE SELECT/FETCH operations ? (I use ESQLC under Solaris7 x86) > Can i increase buffers ? > My configuration "setlitcp" is important for performance ? > > Thank you > Liliano > > Sent via Deja.com http://www.deja.com/ > Before you buy. > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Apart from making sure all your index/sql etc are efficient then all you can really do is tune the OS, and there's not a lot you can do there, mainly disk layout and FS tuning > In article <8h8996$hm4$1@nnrp1.deja.com>, > liliano@my-deja.com wrote: > > Hi, > > Do you know any configuration parameters that improve performance for > > Informix SE SELECT/FETCH operations ? (I use ESQLC under Solaris7 x86) > > Can i increase buffers ? > > My configuration "setlitcp" is important for performance ? > > > > Thank you > > Liliano > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #