Re: Memory Management
Ok, I can example this: our larger table has Number of Rows 441.762.945 Our cpu idle times: 12:30:01 PM CPU %user %nice %system %iowait %steal %idle 12:40:01 PM all 3.39 0.00 0.39 24.61 0.00 71.61 12:50:01 PM all 3.08 0.00 0.32 22.42 0.00 74.18 01:00:01 PM all 3.68 0.00 0.25 10.33 0.00 85.74 01:10:01 PM all 4.46 0.02 0.24 8.89 0.00 86.39 01:20:01 PM all 5.92 0.00 0.24 7.92 0.00 85.92 01:30:01 PM all 6.28 0.00 0.25 6.83 0.00 86.63 01:40:01 PM all 5.60 0.00 0.24 7.77 0.00 86.38 Average: all 6.82 0.00 0.37 9.68 0.00 83.12 Does it means a positive or negative case? Informix is great, in any size, any arch, anywhere. Best regards! Em 02/09/2010 13:37, Obnoxio The Clown escreveu: > shorti wrote: >>>> Thank you...this is exactly what I was looking for. >>> I'm clearly losing my touch. >>> >>> -- >>> Cheers, >>> Obnoxio The Clown >>> >> >> ok..then I will give you another chance to redeem yourself.....Can >> anyone tell me what they think of Informix Performance for a larger >> database...lets say 5-6 + million rows on the main table with multiple >> other tables with the same amount of rows. Is it better to go with >> something like Oracle or DB2 instead. I know, I know...I am asking in >> the Informix forum but seriously..does Informix measure up when it >> comes to larger databases? > No problem. > > In fact, better. > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11
On Sep 2, 10:47 am, Alexandre Marini <amar...@fazenda.ms.gov.br> wrote: > Ok, I can example this: our larger table has > Number of Rows 441.762.945 > > Our cpu idle times: > 12:30:01 PM CPU %user %nice %system %iowait > %steal %idle > 12:40:01 PM all 3.39 0.00 0.39 24.61 > 0.00 71.61 > 12:50:01 PM all 3.08 0.00 0.32 22.42 > 0.00 74.18 > 01:00:01 PM all 3.68 0.00 0.25 10.33 > 0.00 85.74 > 01:10:01 PM all 4.46 0.02 0.24 8.89 > 0.00 86.39 > 01:20:01 PM all 5.92 0.00 0.24 7.92 > 0.00 85.92 > 01:30:01 PM all 6.28 0.00 0.25 6.83 > 0.00 86.63 > 01:40:01 PM all 5.60 0.00 0.24 7.77 > 0.00 86.38 > Average: all 6.82 0.00 0.37 9.68 > 0.00 83.12 > > Does it means a positive or negative case? > > Informix is great, in any size, any arch, anywhere. > > Best regards! > > Em 02/09/2010 13:37, Obnoxio The Clown escreveu: > > > > > shorti wrote: > >>>> Thank you...this is exactly what I was looking for. > >>> I'm clearly losing my touch. > > >>> -- > >>> Cheers, > >>> Obnoxio The Clown > > >> ok..then I will give you another chance to redeem yourself.....Can > >> anyone tell me what they think of Informix Performance for a larger > >> database...lets say 5-6 + million rows on the main table with multiple > >> other tables with the same amount of rows. Is it better to go with > >> something like Oracle or DB2 instead. I know, I know...I am asking in > >> the Informix forum but seriously..does Informix measure up when it > >> comes to larger databases? > > No problem. > > > In fact, better. > > -- > > Alexandre Marini > > Tecnologia da Informação - DBA > > msn: alexandre_mar...@hotmail.com > > SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix > > Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> > > IBM Informix Dynamic Server Certified Professional V10 / V11 Absolutely wonderful! Can you tell me what the memory usage is?
Ok. The instance has 8GB of memory - allocated for the database only. Total of 9GB (physical) amount. Number of sessions? Not much, it´s an DW. But I could tell you better things, yet, on our OLTP with the same hardware. 1200+ sessions, with less allocated memory (5,6 GB for Informix), and an average of 95% idle time during all work times of our company. Best regards. Em 02/09/2010 14:07, shorti escreveu: > On Sep 2, 10:47 am, Alexandre Marini<amar...@fazenda.ms.gov.br> > wrote: >> Ok, I can example this: our larger table has >> Number of Rows 441.762.945 >> >> Our cpu idle times: >> 12:30:01 PM CPU %user %nice %system %iowait >> %steal %idle >> 12:40:01 PM all 3.39 0.00 0.39 24.61 >> 0.00 71.61 >> 12:50:01 PM all 3.08 0.00 0.32 22.42 >> 0.00 74.18 >> 01:00:01 PM all 3.68 0.00 0.25 10.33 >> 0.00 85.74 >> 01:10:01 PM all 4.46 0.02 0.24 8.89 >> 0.00 86.39 >> 01:20:01 PM all 5.92 0.00 0.24 7.92 >> 0.00 85.92 >> 01:30:01 PM all 6.28 0.00 0.25 6.83 >> 0.00 86.63 >> 01:40:01 PM all 5.60 0.00 0.24 7.77 >> 0.00 86.38 >> Average: all 6.82 0.00 0.37 9.68 >> 0.00 83.12 >> >> Does it means a positive or negative case? >> >> Informix is great, in any size, any arch, anywhere. >> >> Best regards! >> >> Em 02/09/2010 13:37, Obnoxio The Clown escreveu: >> >> >> >>> shorti wrote: >>>>>> Thank you...this is exactly what I was looking for. >>>>> I'm clearly losing my touch. >>>>> -- >>>>> Cheers, >>>>> Obnoxio The Clown >>>> ok..then I will give you another chance to redeem yourself.....Can >>>> anyone tell me what they think of Informix Performance for a larger >>>> database...lets say 5-6 + million rows on the main table with multiple >>>> other tables with the same amount of rows. Is it better to go with >>>> something like Oracle or DB2 instead. I know, I know...I am asking in >>>> the Informix forum but seriously..does Informix measure up when it >>>> comes to larger databases? >>> No problem. >>> In fact, better. >> -- >> >> Alexandre Marini >> >> Tecnologia da Informação - DBA >> >> msn: alexandre_mar...@hotmail.com >> >> SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix >> >> Cert-Info-Mgmt_color<Cert-Info-Mgmt_color.jpg> >> >> IBM Informix Dynamic Server Certified Professional V10 / V11 > Absolutely wonderful! Can you tell me what the memory usage is? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11