Re: Does informix is reliable?

From: klute@nads.de > >In article <373AEE5B.1E3F@bloomberg.net>, > kagel@bloomberg.net wrote: > > Christian Hamel wrote: > > ... > > ... our news machines have over 230 chunks at 2GB each > > which is over 460GB on a Sun E6000 w/ 20 CPUs and 6GB RAM. No >problems! > > We have other servers with over 300GB on DG (DGUX) PentiumPro systems > > with 24 CPUs also no problems. IDS 7.xx will take your database to >4TB > > with good disk farm planning and if you need to go beyond that talk to > > ... > >With all these good news about Informix Dynamic Server, does the same >hold true with Informix SE - well, at least in principle? > >I am planning for an installation with only a few GB (not more than 10) >and 35 users working with the database. The server should run on a Linux >machine (Intel based). Does this seem reasonable? Or does SE get to its >limits in this scenario? As long as none of the individual .dat or .idx files exceeds 2GB. A .dat file contains all the data for a table, a .idx contains *all* the indexes for a table in one file. That's an absolute limit. You might start having regular index corruption once a .dat or .idx file exceeds 1GB. Your user base is well within SE's capabilities on a Linux box. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com