[firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?
Hi to all, I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data is stored in one single table that holds a memo field. I'm worried about the size of this table, because as far as I know the maximun table size for version 1.5 is about 36 Gb and I guess I'll soon get close to this limit. How can I tell the size of a single table inside the Fdb file. Thank your for any help. Nando.
Re: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?
Em 14/2/2012 22:46, Nando escreveu: Hi to all, I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data is stored in one single table that holds a memo field. I'm worried about the size of this table, because as far as I know the maximun table size for version 1.5 is about 36 Gb and I guess I'll soon get close to this limit. How can I tell the size of a single table inside the Fdb file. Thank your for any help. Nando. Look on the gstat output for the number of data pages and multiply it by your page size. see you !
RE: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?
I have a Firebird 1.5 database that has grown up to 26.6 Gb. Most of the data is stored in one single table that holds a memo field. I'm worried about the size of this table, because as far as I know the maximun table size for version 1.5 is about 36 Gb and I guess I'll soon get close to this limit. I am 99.9% sure that the limit applies to data not counting blobs. How many rows are in the table? Sean
Re: [firebird-support] Firebird 1.5: How to tell the size of one table inside Fdb file?
Sean, I am 99.9% sure that the limit applies to data not counting blobs. The limit on table size does not include the actual size of blobs, but considers each blob to be eight bytes long. Advance yourself to 100% confident. Cheers, Ann