Subject Re: UUDIs/GUIDs and problem with uuidlib
Author lutterot
> > I need to use UUDIs/GUIDs as primary keys in my DB...
> Don't do this. It's fine to have a UUID as a separate, unique field
> but having it
> as a primary key is not good, not at all.

But this is what I need for this project...

> Why do you use two different UID-techniques in one and the same
database?

The UUIDs are said to be optimized for fast indexing and are smaller,
so that this is the choice for the DB. The GUIDs, however, are the
standardized representation and have to be used on the application
level. I don't know enough about uuidlib's UUIDs to convert them to
GUIDs in the application.

> Implementing UDFs in .NET would be quite a waste of both,
programming time and CPU cycles.

Maybe. But at least I know how to program in C# :-)