Subject | Re: [ib-support] Re: MAX database size |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2002-09-28T12:54:10Z |
"Daniel Rail" <daniel@...> wrote in message
news:5.1.1.2.2.20020925181053.05494688@......
haven't tested under 2K, but NT only allows 180GB concurrent open files. It
is documented under their knowledgebase. Nearly shot me dead in a document
imaging application I was working on. It is a limit on Kernel Memory I
think and the way open files are monitored / mapped / managed in Windows.
The KB articles that discuss this imply that it is a 192 MB limit => about a
180GB file size limit. The system slows to a crawl and slowly dies. It
states it is higher in 2K, but conflicts with itself to state is as between
200 & 450GB.
HIH.
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
news:5.1.1.2.2.20020925181053.05494688@......
> At 25/09/2002 02:49 PM, you wrote:under
> >Daniel,
> > There appears, under NT4.0 and W2K, to be a limit, quite a bit
> >that. Below is some of the e-mail tread, that occured here a month or sohundreds /
> >ago:
> >
> >~~~~~~~~~~~~~~~~~~
> >~~~~~~~~~~~~~~~~~~
> >Fred,
> >
> >Can not have open at any one time files that total 180GB, whether
> >thousands of little files or one big file. The _ is under the at thesame
> >time.Sort of, it is a limit on the handling of concurrent _open_ files. Still
>
> So, Windows documentation is misleading. Because it says it can manage a
> file size up to 16TeraBytes by using 64KB clusters, but it's also stated
> that the max file size limit is up to the size of the volume that the file
> resides. Probably the limitation of 180GB comes from the limitations of a
> combination of Windows and hardware configuration.
haven't tested under 2K, but NT only allows 180GB concurrent open files. It
is documented under their knowledgebase. Nearly shot me dead in a document
imaging application I was working on. It is a limit on Kernel Memory I
think and the way open files are monitored / mapped / managed in Windows.
The KB articles that discuss this imply that it is a 192 MB limit => about a
180GB file size limit. The system slows to a crawl and slowly dies. It
states it is higher in 2K, but conflicts with itself to state is as between
200 & 450GB.
HIH.
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