Ann,

Thank you so much. That's all what I needed to know.

Regards.

Eduardo

"Ann W. Harrison" <aharrison@...> wrote:
At 11:48 AM 5/25/2004, Eduardo Gamboa wrote:

>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?

Eduardo,

Blobs, regardless of size, take only 8 bytes in the
record and the limit is on record numbers. My guess is
that your compressed records will be about 50 bytes long
- maybe a bit longer depending on the use of the
varchar(48). That will allow you to store about 50Gb
of compressed data in the record plus whatever space the
blobs actually take.

As I said earlier, an upcoming version of Firebird
will implement a larger record number, and eliminate the
practical limit on table size.


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]