Glebas wrote:

>Dear Alexandre,
>
>--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
>
>
>>FB 1.0 has version for 32 and 64 bits I/O, the 64 bits remove
>>
>>
>this
>
>
>>limitation, and the limit goes form FB to the filesystem.
>>
>>FB 1.5 and earlier are all 64 bit I/O friendly so the limit you
>>encounter are in your filesystem.
>>
>>see you !
>>
>>
>
>I am using 32-bit WinXP.
>
>

Hi Glebas,

32 bit XP means XP for 32 bit processor.

when I say 32/64 bit I/O that refeers to the pointers for I/O routines.

FB 1.5.2 use 64 bit pointers to handle I/O.

If you right click on your C: drive (or the location where your database
is) and choose properties, one of those properties is the FileSystem,
AFAIK by default XP uses NTFS.

If you look on the message archives you will found a bunch of detailed
discussion about it, but I'll give simple numbers for you:

*Table 13.5 NTFS Size Limits*

Description Limit
Maximum file size Theory: 16 exabytes minus 1 KB (2^64 bytes minus 1 KB)

Implementation: 16 terabytes minus 64 KB (2^44 bytes minus 64 KB)

Maximum volume size Theory: 2^64 clusters minus 1 cluster

Implementation: 256 terabytes minus 64 KB ( 2^32 clusters minus 1 cluster)

Files per volume 4,294,967,295 (2^32 minus 1 file)


So each FB file could be 256 TB minus 64KB in size.

the information comes from this page
http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/Windows/XP/all/reskit/en-us/prkc_fil_tdrn.asp

this is the tinyurl version of the above
*http://tinyurl.com/d7ykc

*

>I don't quite understand, how can I change the filesystem?
>
>

*When I had a FAT disk on NT server there was a tool to conver it, don't
know about modern OS's.

Never had to do it again, all my systems after that uses NTFS by default
(pre-installed software on notebooks)
*

>Basically, the question is: shall I monitor database size to
>see when it goes beyond 2Gb on windows servers or I shall not
>care - db is not going to be corrupted one day?
>
>
>

if you use NTFS you'll reach other internal limits earlier than the
filesystem file size limit for sure.

>Thanks,
>Glebas
>
>
>
>
>

You are welcome !

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br