Thanks for the information.



I'd appreciate if you let me know what's the limits on the size of external
tables?



Thanks,

Hardy









-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of lucas_jessee
Sent: Thursday, July 05, 2007 1:40 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Database Size



Speaking to the limitations of file system sizes alone:

FAT12 has a 32MB file size limit

FAT16 has a 2GB file size limit

FAT32 has a 4GB file size limit

NTFS has a 16EiB file size limit

EXT3 has a 2TB file size limit



I believe the "Firebird limit" on database size depends on the page

size set when you create the database. I definitely have some

Firebird databases that are over 2GB.



I've also read that with an 8K page size you can have BLOB's up to

32GB, so that would imply to me that databases could be at least that

large. Perhaps someone can provide you with an exact answer from the

Firebird side. However, do consider the info above when choosing a

file system.



Luke



--- In firebird-support@yahoogroups.com, "Hardy Sherwood" <HardyS@...>

wrote:

>

> I understand that there is a 2GB limit on Firebird database.

>

>

>

> I'd appreciate if you let me know whether this is correct?

>

>

>

> I'm running Firebird under windows. Does this limit apply to all file

> formats, that is FAT16, FAT32, NTFS?

>

>

>

> Hardy Sherwood

>

> 801 429-2153

>

>

>

>

>

----------------------------------------------------------------------------
-------

> This message and contents are confidential and intended solely for

> the use of the individual or entity to whom they are addressed. If you

> have received this email in error please notify the system manager.

>

> The original email message has been scanned for computer viruses.

>

----------------------------------------------------------------------------
-------

>

>

>

> [Non-text portions of this message have been removed]

>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Visit http://www.firebirdsql.org and click the Resources item

on the main (top) menu. Try Knowledgebase and FAQ links !



Also search the knowledgebases at http://www.ibphoenix.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Yahoo! Groups Links



http://groups.yahoo.com/group/firebird-support/



Individual Email | Traditional



http://groups.yahoo.com/group/firebird-support/join

(Yahoo! ID required)



mailto:firebird-support-digest@yahoogroups.com

mailto:firebird-support-fullfeatured@yahoogroups.com



firebird-support-unsubscribe@yahoogroups.com



http://docs.yahoo.com/info/terms/





[Non-text portions of this message have been removed]