Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-14 23:47, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Doesn't the page size definition as per a database depend on one > designs their database tables and how such tables will be used? The page size doesn't restrict or limit your database design, with the exception of

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-11-15 00:12, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Thanks for clarifying! This is very useful info, especially the > ibexpert.net [1] site. > > Is there a Firebird site that provides details such as CHAR and > VARCHAR max sizes, pageSize size options, etc.? Most

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
Thanks for clarifying! This is very useful info, especially the ibexpert.net site. Is there a Firebird site that provides details such as CHAR and VARCHAR max sizes, pageSize size options, etc.? ``` On Thu, Nov 14, 2019 at 5:07 PM Dimitry Sibiryakov s...@ibphoenix.com

Re: [firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.11.2019 23:47, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Doesn't the page size definition as per a database depend on one designs > their database > tables and how such tables will be used? Cases when pages of smaller size have a speed advantage are very special and

[firebird-support] Re: What is the optimum pageSize?

2019-11-14 Thread blackfalconsoftw...@outlook.com [firebird-support]
Doesn't the page size definition as per a database depend on one designs their database tables and how such tables will be used? In any event, here is what the Developer Guide for version 3.0 of Firebird states... The actively supported versions of Firebird support the following page