[opencms-dev] OCMS 6beta1: questions about database design

[Kai Schliemann]

Hi list,

in our company came up a few questions about the database design (mostly
from our db specialist) for the new 6 beta1. I want to forward them to you
for discussion and exchange of experiences with it. Especially what
performance is concerned.

1. Why are all IDs now UUIDs?
2. Why are primary keys now relatively long varchars and no integers?
3. Did anyone do any performance testing especially on this issue and what
were the results?
4. Can anyone tell the advantages and disadvantages of UUIDs?

Possible suggestions for optimization from our side are:

1. Usage of an internal integer ID as primary key in parallel and as
addition to the UUIDs
2. Usage of datatype fixed char instead of varchar


Looking forward to a good an valuable discussion on this issue.

Thanks in advance.

Regards

i.A. Kai Schliemann
IT-Consultant
____________________________________________
comundus IT-Beratung GmbH
Schüttelgrabenring 3, 71332 Waiblingen

Tel:    +49 (0) 71 51-5 00 28-0   Fax: -99

www.comundus.com    www.comundus-e-quality.com
____________________________________________