Subject Re: [firebird-support] Re: Primary Keys - [was] Database File Size
Author Eduardo Gamboa
Ann,

My tables have 2 integer fields, one timestamp field, one varchar(16), one varchar(48), one char(1) and one Blob field subtype 0 segment size 80 (used for images).

I would like to know what would the max table size be?
The size of the image recorded in the blob field may vary.

Please your help.

Eduardo



"Ann W. Harrison" <aharrison@...> wrote:
The maximum table size depends on the average compressed length of
records. It goes from, well, 0 for records with no data, to 20 Gb
for records with an average compressed length of about 10 bytes to
62Gb for records with an average length of about 100 bytes, to about
70Gb for 500 byte records.


Regards,


Ann


Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger

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