Monday 16 May 2011

Index on uuid when using NHibernate

Guid is a simple and easy solution for generate random ids.
However, when a table is using uuid as the key, it's not so simple to index base on ids.

Here is a good blog showing how you can create your own id generator that taking advantage of the uuid and give you a result id that can be indexed.



Using guid id in nhibernate, index fragmentation

No comments:

Post a Comment