[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: repository GUIDs

From: Karl Fogel <kfogel_at_newton.ch.collab.net>
Date: 2002-12-12 21:20:35 CET

"Bill Tutt" <rassilon@lyra.org> writes:
> It feels right, but sometimes it's necessary to cluster an index on an
> Alternative Key or indeed even on a non-unique column rather than the
> Primary Key for various reasons. The reasons in this case are space
> optimization related. Our funky base-whatever IDs are much shorter than
> the number of bytes a GUID has. Monotonically increasing integers also
> use a B+-tree index more efficiently.

I understand the justification, I'm just saying let's see a
measurement of performance improvement before we make this simplicity

We've optimized prematurely in some other cases. I don't *know* that
this is such a case, but shouldn't we find out first?


To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Thu Dec 12 22:00:12 2002

This is an archived mail posted to the Subversion Dev mailing list.