Subject | Re: [firebird-support] maximum index key size still 252 in FB 1.5? |
---|---|
Author | Arno Brinkman |
Post date | 2004-05-10T06:44:12Z |
Hi,
FB1.5 is not so long time ago released thus don't expect it next week. The
size will be 1/4 of the page_size.
the key the more index pages are needed.
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com
Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info
> If yes, is it expected to be increased in FB 2.0 andYes, you can expect that it would be increased in FB2.0, but remember that
> to what size?
FB1.5 is not so long time ago released thus don't expect it next week. The
size will be 1/4 of the page_size.
> How urgent an issue is this considered?It's better to keep your indexes so small as possible, because the larger
the key the more index pages are needed.
Regards,
Arno Brinkman
ABVisie
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/
Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com
Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info