Subject RE: [firebird-support] Who's using some GUID (Global Unique IDentifiers) in FB?
Author Alan McDonald
> Hello,
>
> Can you advise me about "Global Unique IDentifiers", which Udf to use
> and is it really efficient ?
> I want ot use it in order to do disconnected works with data and
> after update database.
> It would be nice if you have a little exemple.
> Thanks you.
>
>

There may only be measureable performance hits using this method at the very
large table size, then again maybe not.
Another method which I use with disconnected Palm, records which are
inserted onto Palm get a negative PK (easy on palm - also easy to do on
desktop app), then on Sync (Palm HotSync), the new records are inserted
after getting real integer PK, and relations are then maintained by
inserting with this real OK and FKs. (Palms don't know about GUIDs
natively). This method allows for server side PK generator in native sense.
Alan