Re: ORACLE vs INFORMIX vs MS SQL SERVER

Art S. Kagel wrote: > That requires a 64bit machine with 64bit OS and 64bit Informix version > (ie currently HP/UX 11 or Solaris 2.? (64bit vers) with IDS 7.30FC3 (64 > bit version) only). No, I don't think the 64-bit architecture buys you anything here. You probably need XPS (oops, I mean IDS 8.x or IDS/ADO or X-whatever) for this database. > The data limit for a 32bit Informix IDS instance is 2TB of data total > (1024 chunks @ 2GB each == 2TB). 2047 chunks @ 2GB (or 4GB, on a 4K pagesize port) = ~4TB (or 8TB). It probably wouldn't be a big deal for Informix to support 4095 chunks and increase that to 8TB (16TB), just requires some testing that they haven't done yet. > Only 64bit implementations overcome > this by a) allowing chunks > 2GB No, I don't think they do. > and b) increasing pagesize to 4K > which allows 2048 chunks. 64-bit implementations don't increase pagesize to 4K, nor does pagesize affect max # chunks. Sorry, Art, but I think you are either sleep-deprived or on drugs today. June -- june_t@hotmail.com Grounded in Palo Alto, living on Cafe Mocha