On Wed, Jan 19, 2011 at 12:13 PM, Thomas Steinmaurer <ts@...>wrote:

>
>
> Hi Alex,
>
>
> > I've heard that FB 2.5 supports 32K and 64K pages. Is this true? What
> page
> > sizes does FB 2.1.x support?
>
> It isn't true. The max. page size in FB 2.5 remains 16K.
>
>
> > A somewhat related question is how large should the page size be to allow
> me
> > to index varchar(2048) column with UTF8 character set?
>
> You won't be able to index that. The formula for the max. index key size
> is:
>
> (Page Size / 4) - 4
>
> There is also Ivan's key size calculator you can play around with:
> http://www.volny.cz/iprenosil/interbase/ip_ib_indexcalculator.htm
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>


[Non-text portions of this message have been removed]