Re: SE table sizes

From: "Mackenzie, Chris" <Chris.Mackenzie@bskyb.com> > >We are currently running SE 5.10 and throwing more data at it than is >probably good for it (compensating with a large box). >We are about to ramp to 1200ish concurrent users and start heaving even >more >data into it (I know I know - but.....). I think you're f***ing mad, is the short answer. :-( Well, maybe not you personally, but you know what I mean. :-) >Some of our tables are approaching 1gig in size and there are vague >memories here of SE having problems with tables over 1G. Yep. You start to get fairly regular index corruption, probably have to bcheck your bigger tables on a daily or twice daily basis. (I don't know if it still applies to 5.10, but this was certainly the case with, for example, 5.06) Can you afford that kind of downtime? >Anyone got any experience of these kind of problems or are we just >Whistling >Dixie. I think a funeral march might be more appropriate. :-) Look, I'm probably the world's greatest fan of Informix SE, believe me, but 1200+ users *and* individual .dat or .idx files over 1GB is just begging for grievous mental harm.... Just in case you missed the point: bite the bullet and upgrade to IDS 7.3. Quickly. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com