Re: Recomended max datafile size

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 21 May 2003 18:30:05 -0700
Message-ID: <73e20c6c.0305211730.1ef11d40@posting.google.com>

"Ryan" <rgaffuri_at_cox.net> wrote in message news:<YuSya.50016$823.32024_at_news1.east.cox.net>...

> 2gb? What if you are on a terabyte or multi-terabyte system? Your talking
> 500 datafiles plus. is that standard?
>

500 datafiles is no worry. Still:

If you are in such a system, you better have 64-bit hardware and a proper 64-bit OS. In that case, your limit won't be 2Gb but more like the next "bug" boundary: 64Gb. The important thing is to not set the filesize RIGHT on the boundary: that's where you expose yourself to "off-by-one" bugs.

> not criticizing. just asking.

Hey, no worries! Most welcome.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed May 21 2003 - 20:30:05 CDT