Subject | Re: [IB-Architect] Next ODS change (was: System table change) |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2000-11-08T16:11:53Z |
Hello, Ann!
Ann Harrison wrote:
than X bytes (for example 64 or 84)?
I mean, with B-tree index we can search =, > or <. I don't know applications that
can differ strings longer than ~80 characters. I think indexing the whole 2K or even 64K is
completely useless.
There are about ~60 wishes now :-) Yours N5 already in it.
--
Dmitry Kuzmenko, Epsylon Technologies.
Ann Harrison wrote:
> Other things to consider for the ODS change include:I've heard that IB 5.x does not store or use page checksum.
>
> 1) Drop page checksum
> 2) Add page generation at bottom of page for a consistency check.cool! But.... Maybe it is much easier to do "silent key trimming" when key size is bigger
> 3) Increase max index key size from 255 to 64K.
than X bytes (for example 64 or 84)?
I mean, with B-tree index we can search =, > or <. I don't know applications that
can differ strings longer than ~80 characters. I think indexing the whole 2K or even 64K is
completely useless.
> 5) Add FK root page (like IRT) so defining foreign keys doesn'tI have temporary wishlist, local for russian IB users.
> require exclusive access.
There are about ~60 wishes now :-) Yours N5 already in it.
--
Dmitry Kuzmenko, Epsylon Technologies.