Re: Memory Management

On 02-09-2010 18:28, 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? Are you serious? No offense... It really depends on your hardware, application and personal ability... But Informix is used in environments with ten's or hundred's of tables with millions of rows... With thousands of concurrent sessions... I could give you some interesting numbers... but the point is that 6M rows is nothing these days... Of course, if you want to cross that table with another of that size (all set of data) it will take a while... But that's not the usual OLTP use. Regards.