Subject | Calculating Key Size |
---|---|
Author | uak6wv |
Post date | 2004-03-04T09:16:32Z |
Hi!
How can I determine the size of a key knowing the size (in byte) of
the included fields? (Or where can I find the appropriate parts in the
source code?)
Mainly I want to create unique keys using one as long as possible
varchar field and some UUID field (char(22)). In some cases I have to
use additional integer fields.
I made some test and get the following results:
1. Varchar(252)
2. Varchar(132) + 1 UUID field
2. Varchar(64 ) + 2 UUID field
4. Varchar(40 ) + 3 UUID field
How can I determine the size of a key knowing the size (in byte) of
the included fields? (Or where can I find the appropriate parts in the
source code?)
Mainly I want to create unique keys using one as long as possible
varchar field and some UUID field (char(22)). In some cases I have to
use additional integer fields.
I made some test and get the following results:
1. Varchar(252)
2. Varchar(132) + 1 UUID field
2. Varchar(64 ) + 2 UUID field
4. Varchar(40 ) + 3 UUID field