Subject | uniqueidentifier data type and performance |
---|---|
Author | martinthrelly |
Post date | 2007-03-24T22:25:38Z |
hello there. we are considering porting a project to Firebird 2.0. the
only stumbling block for us is regarding the uniqueidentifier data type.
the project in question uses uniqueidentifiers as primary keys. this is
because there is replication involved between different sites. i
discovered that there is no inbuilt GUID type. so i have a couple of
questions please:
1. what is the best way for me to implement a GUID type in Firebird 2.0?
2. i am guessing that if i have to manually create a GUID then it will
be a varchar or something like that. i am concerned that there may be
performance issues here by using such a datatype as the primary key
index. for searching, etc.
any useful feedback and additional comments on this would be most
welcome as i have not used uniqueidentifiers with firebird before.
only stumbling block for us is regarding the uniqueidentifier data type.
the project in question uses uniqueidentifiers as primary keys. this is
because there is replication involved between different sites. i
discovered that there is no inbuilt GUID type. so i have a couple of
questions please:
1. what is the best way for me to implement a GUID type in Firebird 2.0?
2. i am guessing that if i have to manually create a GUID then it will
be a varchar or something like that. i am concerned that there may be
performance issues here by using such a datatype as the primary key
index. for searching, etc.
any useful feedback and additional comments on this would be most
welcome as i have not used uniqueidentifiers with firebird before.