Re: Problems runing informix se on sco open server

David Williams said: > > "'lvaro Prieto" <aprieto@sedasolubles.com> wrote in message > news:c9k5je$8lh$1@news.xmission.com... >> >> We are having problems running sco 5.0 and informix se, the platform we > are >> using is the next: >> >> hp proliant (or compaq) server, having two PIV xenon processor with two >> Gb >> of main memory, >> Equipped with an array card and three scsi disks (10000 rpm). We have >> charged all the software SCO recommends >> for using de second processor, and for protect them, (it appears to have >> some risk in using sco over Xenon without this patch). >> >> May every one help us on improving the efficiency of our system? the > actual >> velocity is absolutely unnadecuated for the machine we are using >> It exists some configuration or improvement method for the SCO or for >> the >> Informix SE? >> > > - Look under $INFORMIXDIR/release and check kernel parameters are set > correctly. > - Check how the kernel parameters affect the size of the buffer cache in > SCO. There > are lots of kernel tunables for the buffer cache under SCO. > - Use SET EXPLAIN ON in the application to see what is happening. > Sequential > scans > on large tables are a bad idea! Which probably means you need some indexes. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "Necrophilia means never having to say ... well, anything!" - Captain Pedantic "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco sending to informix-list