Re: uuid, COMB uuid, distributed farms

Good catch! The article is:

http://www.informit.com/articles/printerfriendly.aspx?p=25862

Dennis Gearon

Signature Warning
----------------
It is always a good idea to learn from your own mistakes. It is usually a better
idea to learn from others’ mistakes, so you do not have to make them yourself.
from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036'

EARTH has a Right To Life,
otherwise we all die.

----- Original Message ----
From: bricklen <bricklen(at)gmail(dot)com>
To: Dennis Gearon <gearond(at)sbcglobal(dot)net>
Sent: Sun, January 2, 2011 8:49:13 PM
Subject: Re: [GENERAL] uuid, COMB uuid, distributed farms

On Sun, Jan 2, 2011 at 8:26 PM, Dennis Gearon <gearond(at)sbcglobal(dot)net> wrote:
> On the tests in this article, doing large amounts of consecutive inserts,
> generating new UUIDs, and having the indexes getting updated caused a 30
> (THIRTY) times increase in time to do inserts. So he came up with a function
> that caused the lowest characters of the UUIDs to change slowly according to
> time in microseconds. This reduced the time to using UUIDs for PKs for inserts
> and joins BOTH by only 10% relative to SEQUENCES and their integer primary
>keys.

I think you forgot to link to the article?