RE: New Server- How to Optimise

If you need to ask this you really really really need to go on a course or at least read a manual Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # forever www.wfsoftware.com # > -----Original Message----- > From: Kirk Davis [mailto:kirk@kirkdavis.co.uk] > Sent: Wednesday, June 21, 2000 3:12 PM > To: informix-list@iiug.org > Subject: Re: New Server- How to Optimise > > > Thanks, will give that a go, > > > NUMCPUVPS 3 > > MULTIPROCESSOR 1 > > SINGLE_CPU_VP 0> > Are these in the informix.conf file?? > > Where do I increase the buffer? and what to? > > Obnoxio The Clown <obnoxio@hotmail.com> wrote in message > news:8iqbps$f1j$1@news.xmission.com... > > > > From: "Kirk Davis" <kirk@kirkdavis.co.uk> > > > > > >We have just upgraded our Informix Dynamic Server 7.3 > hardware to a 4 * > > >550mhz Xeon with 1024mb RAM.. The platform was previously > a single 200mhz > > >Pentium wth 256mb RAM. > > > > > >We have now imported the database. What is the next step > to optimise the > > >system?? > > > > UPDATE STATISTICS> > > > And > > > > NUMCPUVPS 3 > > MULTIPROCESSOR 1 > > SINGLE_CPU_VP 0> > > > More BUFFERS. > > > ______________________________________________________________ > __________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

Been on a course, RTFM! Just wanted to check with you guys that what I was doing was the correct way to go... Kirk Watson Paul <Paul.Watson@fefc.ac.uk> wrote in message news:8iqv46$pfi$1@news.xmission.com... > > If you need to ask this you really really really need to go on a course > or at least read a manual > > Paul Watson # > WF Software Ltd # You are only young once > Tel: +44 1436 674729 # but you can be immature > Fax: +44 1436 678693 # forever > www.wfsoftware.com # > > > > -----Original Message----- > > From: Kirk Davis [mailto:kirk@kirkdavis.co.uk] > > Sent: Wednesday, June 21, 2000 3:12 PM > > To: informix-list@iiug.org > > Subject: Re: New Server- How to Optimise > > > > > > Thanks, will give that a go, > > > > > NUMCPUVPS 3 > > > MULTIPROCESSOR 1 > > > SINGLE_CPU_VP 0> > > > Are these in the informix.conf file?? > > > > Where do I increase the buffer? and what to? > > > > Obnoxio The Clown <obnoxio@hotmail.com> wrote in message > > news:8iqbps$f1j$1@news.xmission.com... > > > > > > From: "Kirk Davis" <kirk@kirkdavis.co.uk> > > > > > > > >We have just upgraded our Informix Dynamic Server 7.3 > > hardware to a 4 * > > > >550mhz Xeon with 1024mb RAM.. The platform was previously > > a single 200mhz > > > >Pentium wth 256mb RAM. > > > > > > > >We have now imported the database. What is the next step > > to optimise the > > > >system?? > > > > > > UPDATE STATISTICS> > > > > > And > > > > > > NUMCPUVPS 3 > > > MULTIPROCESSOR 1 > > > SINGLE_CPU_VP 0> > > > > > More BUFFERS. > > > > > ______________________________________________________________ > > __________ > > > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com > > > > > > The contents of this e-mail are confidential to the ordinary user(s) of the > mail address(es) to which it was sent and may be legally privileged. > If you are not the intended recipient, any disclosure, copying, distribution > or use of it, or any part of it, in any form whatsoever, and any actions > taken or omitted to be taken in reliance on it, is prohibited and may be > unlawful. > >

Kirk, we know it's because your stupid, and are trying to hide it :o) He,he -Ryan Kirk Davis wrote in message <8isfk6$g0u$1@vg170.it.volvo.se>... >Been on a course, RTFM! > >Just wanted to check with you guys that what I was doing was the correct way >to go... > >Kirk > >Watson Paul <Paul.Watson@fefc.ac.uk> wrote in message >news:8iqv46$pfi$1@news.xmission.com... >> >> If you need to ask this you really really really need to go on a course >> or at least read a manual >> >> Paul Watson # >> WF Software Ltd # You are only young once >> Tel: +44 1436 674729 # but you can be immature >> Fax: +44 1436 678693 # forever >> www.wfsoftware.com # >> >> >> > -----Original Message----- >> > From: Kirk Davis [mailto:kirk@kirkdavis.co.uk] >> > Sent: Wednesday, June 21, 2000 3:12 PM >> > To: informix-list@iiug.org >> > Subject: Re: New Server- How to Optimise >> > >> > >> > Thanks, will give that a go, >> > >> > > NUMCPUVPS 3 >> > > MULTIPROCESSOR 1 >> > > SINGLE_CPU_VP 0>> > >> > Are these in the informix.conf file?? >> > >> > Where do I increase the buffer? and what to? >> > >> > Obnoxio The Clown <obnoxio@hotmail.com> wrote in message >> > news:8iqbps$f1j$1@news.xmission.com... >> > > >> > > From: "Kirk Davis" <kirk@kirkdavis.co.uk> >> > > > >> > > >We have just upgraded our Informix Dynamic Server 7.3 >> > hardware to a 4 * >> > > >550mhz Xeon with 1024mb RAM.. The platform was previously >> > a single 200mhz >> > > >Pentium wth 256mb RAM. >> > > > >> > > >We have now imported the database. What is the next step >> > to optimise the >> > > >system?? >> > > >> > > UPDATE STATISTICS>> > > >> > > And >> > > >> > > NUMCPUVPS 3 >> > > MULTIPROCESSOR 1 >> > > SINGLE_CPU_VP 0>> > > >> > > More BUFFERS. >