Subject | Re: [IB-Architect] Next ODS change (was: System table change) |
---|---|
Author | Ann Harrison |
Post date | 2000-11-07T16:43:31Z |
At 11:10 AM 11/7/2000 -0500, Leyne, Sean wrote:
Personally, I'd go for varchar[255].
Other things to consider for the ODS change include:
1) Drop page checksum
2) Add page generation at bottom of page for a consistency check.
3) Increase max index key size from 255 to 64K.
4) Promote dbKey in non-unique indexes to eliminate duplicates.
5) Add FK root page (like IRT) so defining foreign keys doesn't
require exclusive access.
6) Improve compression algorithm for large fields.
I'm sure there are more.
Regards,
Ann
>On the subject of the next ODS change, what would it take to increaseSlightly messy, but probably a good chance for a general cleanup.
>the namespace size of the DB object from 31 to, say, 63 characters?
Personally, I'd go for varchar[255].
Other things to consider for the ODS change include:
1) Drop page checksum
2) Add page generation at bottom of page for a consistency check.
3) Increase max index key size from 255 to 64K.
4) Promote dbKey in non-unique indexes to eliminate duplicates.
5) Add FK root page (like IRT) so defining foreign keys doesn't
require exclusive access.
6) Improve compression algorithm for large fields.
I'm sure there are more.
Regards,
Ann