Subject | Re: [Firebird-Architect] Re: Digest Number 959 |
---|---|
Author | Kevin Berry |
Post date | 2005-03-24T15:53:21Z |
Is it possible to call this library without doing
database access? I'd like to assign the GUIDs in my
app, rather than in the database.
Thanks,
Kevin.
--- "Ian A. Newby" <iann@...> wrote:
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
database access? I'd like to assign the GUIDs in my
app, rather than in the database.
Thanks,
Kevin.
--- "Ian A. Newby" <iann@...> wrote:
>__________________________________________________
>
> Hi Folks,
> The UUIDLib library which I (had) wrote uses the
> original method of
> guid generation, and produces a reversed shrunken
> version (22 chars
> all of which are url friendly), so the index prefix
> compression works ok.
>
> Regards
> Ian Newby
>
> --- In Firebird-Architect@yahoogroups.com, Kevin
> Berry
> <kevinbe71@y...> wrote:
> > Thanks Ann. Nice theory but....
> >
> > Here are two serial GUIDs (i.e. produced a split
> > second apart from one another on my system):
> >
> > 255DAB3A-E481-4F8B-BE8A-EEB079DA9101
> > 63ECDA6A-4906-4F54-8F54-D6C73386E989
> >
> > Try to spot the bits they have in common. ;-)
> >
> > Microsoft started out by making GUIDs serial
> but....
> > as the Melissa author discovered... this allowed
> > people to determine which machine produced the
> GUIDs.
> > See reference below (section titled "Algorithm"):
> >
> > http://en.wikipedia.org/wiki/GUID
> >
> > Of course, if you're using some other algorithm
> that
> > is not the Microsoft one then I guess this could
> still
> > hold true. However, I like to assign a GUID by a
> > system call and using the value in my objects
> > directly... rather than waiting for the database
> to
> > assign one and then having to retrieve it from
> some
> > output var. This has the added benefit of objects
> in
> > memory having unique IDs even if they haven't been
> > stored in the database yet.
> >
> > Cheers,
> > Kevin.
> >
> > --- "Ann W. Harrison" <aharrison@i...> wrote:
> > > > "reversed GUID" sounds like something you
> > > > made up?
> > >
> > > A GUID is a string of bytes that is "guaranteed"
> to
> > > be unique. It
> > > starts with a counter and adds factors that are
> > > constant for a
> > > particular computer. Firebird uses prefix
> > > compression on its indexes,
> > > so having the constant part first reduces the
> size
> > > of indexes by a lot.
> > >
> > > Regards,
> > > Ann
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new resources
> site!
> > http://smallbusiness.yahoo.com/resources/
>
>
>
>
>
>
> Yahoo! Groups Links
>
> http://groups.yahoo.com/group/Firebird-Architect/
>
> Firebird-Architect-unsubscribe@yahoogroups.com
>
>
>
>
>
>
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com