Daniel,
There appears, under NT4.0 and W2K, to be a limit, quite a bit under
that. Below is some of the e-mail tread, that occured here a month or so
ago:

~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~
Fred,

Can not have open at any one time files that total 180GB, whether hundreds /
thousands of little files or one big file. The _ is under the at the same
time.

JAC.

""Wilson, Fred"" <fred.wilson@...> wrote in message
news:E9E4431A916AD21191FD00104B986AEFC23E5B@......

> Jason is this 180Gigs of files at the same time, as in 180gig's of file
> handles, as in 10 files open, 10,000 files open, etc.. Or, is this 180GB

of

> file size(s) open. In other words couldn't open more that 180 files (at

the

> same time) that are 1 gig in size each, or couldn't open 1 file that's,

say

> 300 gig ? If the second part is true, this is, in effect, saying that a
> database can't be larger than 180GB
> My head hurts ;)
>
>
> Best regards,
> Fred Wilson
> SE, Bell & Howell
> fred.wilson@...
>
>
> -----Original Message-----
> From: Jason Chapman (JAC2) [mailto:jason@...]
> Sent: Tuesday, July 23, 2002 10:47 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] FIB and filesize
>
>
> Fred,
>
> No you're not confused at all, NT can not have more than 180GB of files

open

> at any one time. The limit on 2K is 192, 24? or 3?? depending on which
> documentation you look at.
>
> We couldn't find any OS tweak to get around it.
>
> We had this problem with a database server with > 20 x 20GB databases,

after

> a while the server just stopped. After an age of investigation we got the
> problme down to this limit in NT4.
>
> > Jason Chapman
> >
> > JAC2 Consultancy
> >
> >
> >
> > Training - Development - Consultancy
> >
> > Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
> > Troubleshooting projects, QA.....
> >
> > www: When I get round to it....
> >
> > Mob: (+44) 07966 211 959 (preferred)
> >
> > Tel: (+44) 01928 751088
>
>
>
>
> ""Wilson, Fred"" > Jason, I'm slightly confused (but for me that's a

common

> state of mind ;) )
> > about your e-mail. Are you saying that BT4.0 has a max file size

(limited

> by
> > the max file open size) of only 180GB and W2K maybe something more ??
> >
> > Best regards,
> > Fred Wilson

~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~


Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...



-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Tuesday, September 24, 2002 3:59 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Re: MAX database size


At 23/09/2002 12:52 PM, you wrote:

>Certainly not on Windows platforms. There was a thread on this just
>recently. NT (and I believe W2K, though the limit may be a little

different)

>has a 182G limit on the maximum size of files that can be open at any one
>time...

On Win2000, the file addressing is 48 bit. So just a "fast" calculation
yields a result of 32,768GB. But, you still need the hardware to utilize
that kind of addressing.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)


-