Re: ORACLE vs INFORMIX vs MS SQL SERVER

Art S. Kagel wrote: [snip] > 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). > > The data limit for a 32bit Informix IDS instance is 2TB of data total > (1024 chunks @ 2GB each == 2TB). Only 64bit implementations overcome > this by a) allowing chunks > 2GB and b) increasing pagesize to 4K > which allows 2048 chunks. On 64bit the data is virtually unlimited. > With 18GB drive as a single chunk 2048 chunks = 36TB and using RAID > to create larger virtual drives the sky is the limit since the OS > limits llseek() offsets to 1024GB for RAW devices that makes the actual > hard limit 2048TB. (What is that called 2PetaBytes?) > > Art S. Kagel Current 7.x and 9.x versions of informix can all have 2047 chunks reguardless of wether or not they are 32bit or 64bit. I'm also pretty sure that 64bit version of informix also has the 2gig chunk size limit. Only machines of 4K pages can have 4gig chunks. Although I think 64bit versions can probably have offsets for chunks >2gig. I haven't worked with XPS (8.x) so I'm not sure of its chunk limitations. I do know that there is work in progress for 9.x and possibly later versions of 7.x to allow 4095 chunks which would double the amount of data we could hold. Jacques -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************