On 2019-11-17 12:22, jerz...@o2.pl [firebird-support] wrote:
> On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel
> m...@lawinegevaar.nl [firebird-support] wrote:
>> Because it is hard to do. A lot of internals in Firebird and its
>> clients
>> rely on this maximum size (hint: the number itself
> On Nov 17, 2019, at 6:22 AM, jerz...@o2.pl [firebird-support]
> wrote:
>
> On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>
In Release Notes for these versions.
Maximum size of record was not changed.
>
>
>>> This is a
17.11.2019 12:22, jerz...@o2.pl [firebird-support] wrote:
> > Because it is hard to do. A lot of internals in Firebird and its clients
> > rely on this maximum size (hint: the number itself fits in a 2-byte
> > unsigned integer). It is not like you just need to update a MAX_ROW_SIZE
> >
On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
>>> In Release Notes for these versions.
>>> Maximum size of record was not changed.
>> This is a very big limitation, a few larger char fields with multibyte
>> coding and we get an
16.11.2019 09:33, jerz...@o2.pl [firebird-support] wrote:
> a few larger char fields with multibyte coding and we get an exception.
An entity with several large text attributes is unusual. Can you provide an
example?
--
WBR, SD.
On 16-11-2019 09:33, jerz...@o2.pl [firebird-support] wrote:
>
>>> But only for FB 2.5, not for FB3!
>>> My question was about FB3. Where is info about new versions?
>
>> In Release Notes for these versions.
>> Maximum size of record was not changed.
>
>
> This is a very big
>> But only for FB 2.5, not for FB3!
>> My question was about FB3. Where is info about new versions?
>In Release Notes for these versions.
>Maximum size of record was not changed.
This is a very big limitation, a few larger char fields with multibyte coding
and we get an exception. I
15.11.2019 22:09, jerz...@o2.pl [firebird-support] wrote:
> But only for FB 2.5, not for FB3!
> My question was about FB3. Where is info about new versions?
In Release Notes for these versions.
Maximum size of record was not changed.
--
WBR, SD.
But only for FB 2.5, not for FB3!
My question was about FB3. Where is info about new versions?
> This is very useful info!!!
On Fri, Nov 15, 2019 at 5:13 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
>> What is
This is very useful info!!!
On Fri, Nov 15, 2019 at 5:13 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
> > What is the max record size in FB3 (in bytes)?
> > I search for this information without success.
>
>
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote:
> What is the max record size in FB3 (in bytes)?
> I search for this information without success.
https://firebirdsql.org/en/firebird-technical-specifications/
--
WBR, SD.
>> Does each record consume a page, or are could there be multiple records on a
>> page?
>Multiple records can be on one data page or one record can be split to
> several database
> pages depending on record's size.
What is the max record size in FB3 (in bytes)?
I search for this
14.11.2019 23:30, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote:
> What is the max page size for Firebird 3?
16 kilobytes.
> Also, could you clarify a page?
Quoting
What is the max page size for Firebird 3?
Also, could you clarify a page? Does each record consume a page, or are
could there be multiple records on a page?
`
On Thu, Nov 14, 2019 at 8:09 AM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 14.11.2019 13:41,
14.11.2019 13:41, cte...@gmail.com [firebird-support] wrote:
> Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
> CHARACTER SET
> UTF8" --- what is the optimum pageSize?
Optimum page size doesn't depend on data but on application usage.
I can repeat once again:
Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191)
CHARACTER SET UTF8" --- what is the optimum pageSize?
16 matches
Mail list logo