[Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
I'm looking at updating https://firebirdsql.org/en/firebird-technical-specifications/, but I'm wondering if anything changed for some of the sizes listed on that page. Specifically, does the introduction of page size 32KB change anything for the maximum file size and maximum size of one table?

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Jiří Činčura
Definitely BLOB size should be bigger. Index key length too. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
On 06-08-2021 14:37, Jiří Činčura wrote: Definitely BLOB size should be bigger. Index key length too. Good point, index key length I was aware of. What would be the new max size of blobs? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/li

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Dimitry Sibiryakov
06.08.2021 14:55, Mark Rotteveel wrote: What would be the new max size of blobs? Nothing changed about BLOBs. It is still limited to uint32 for total size and seek location. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Mark Rotteveel
On 06-08-2021 16:16, Dimitry Sibiryakov wrote: 06.08.2021 14:55, Mark Rotteveel wrote: What would be the new max size of blobs?   Nothing changed about BLOBs. It is still limited to uint32 for total size and seek location. That document says <32GB for blob, if it is restricted to unit32, t

Re: [Firebird-devel] File and table sizes in Firebird 4.0

2021-08-06 Thread Dimitry Sibiryakov
06.08.2021 18:11, Mark Rotteveel wrote: That document says <32GB for blob, if it is restricted to unit32, then the limit should be <4GB, right? Limit is 4GB for corresponding info item. The BLOB itself can be longer if you "just read/write" it. -- WBR, SD. Firebird-Devel mailing list,