Re: [firebird-support] Re: What is the optimum pageSize?
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 indexable items. The maximum keysize is slightly less than 1/4 of the page size. This means that with a page size of 4096, the max you can index is +/- VARCHAR(1020) in a single byte character set or +/- VARCHAR(256) UTF8 (I'm saying +/- here because exact size depends on collations etc), while with page size 16384, the maximum is +/- VARCHAR(4092) single byte character set / VARCHAR(1023) UTF8. That said, trying to avoid such oversized indexes would be better: the more keys fit on a single page, the more efficient the index. With a larger page size, more records will fit on a single page (or very wide records might fit on less pages). Page size can have influence on performance, and generally larger page sizes are 'better' (although that also depends on the underlying storage). However, if you use a lot of relatively small blobs, you could be wasting more diskspace. Mark
Re: [firebird-support] Re: What is the optimum pageSize?
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 of it is described in the Firebird 2.5 Language Reference: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25.html Datatype sizes: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes.html Page sizes: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-db.html If you're using Firebird 3, also consult the Firebird 3 release notes for things introduce or changed: https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html Mark
Re: [firebird-support] Re: What is the optimum pageSize?
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 [firebird-support] wrote: > 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 most of > database developers won't ever hit them. In common case small pages cause > slowdown. > > > -- >WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] Re: What is the optimum pageSize?
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 most of database developers won't ever hit them. In common case small pages cause slowdown. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: What is the optimum pageSize?
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 sizes: 4096, 8192 and 16384. The page size of 8192 is good for most cases. This is rather ambiguous for most database developers looking to optimize their databases. So a link to the IB-Experts site provides more guidelines on selecting database, page sizes. The information is somewhat dated as to the references to the earlier Firebird versions but the design information is credible as it relaters fairly standardized design paradigms in the industry... https://www.ibexpert.net/ibe/index.php?n=Doc.PageSize https://www.ibexpert.net/ibe/index.php?n=Doc.PageSize Steve Naidamast Sr. Software Engineer