Performance - string ID vs int ID
Posted: Thu Jun 22, 2006 7:43 am
Right now I am developing a PHP app which is going to use the data of users and user groups stored in Active Directory server. I have decided to refer and identify users and user groups in AD using "objectGUID" property. Since the same users are going to have their entries (as well as any app-specific data assigned to them) stored in my app's db, I was wondering if there would be a noticeable performance hit if I used base64 encoded "objectGUID"s as IDs instead of the usual integers? Obviously, in this case any ID based relations stored in other db tables would have to store base64 strings. Since objectGUID is already an object ID in Active Directory, I am a bit reluctant to add additional integer IDs in my app's db since objectGUID is guaranteed to be unique, however, if the performance may suffer noticeably, I would change my mind. Btw, base64 encoded objectGUIDs I think are no less than ~20 chars.
Btw, I am going to use SQL Server 2000 db for my app.
Btw, I am going to use SQL Server 2000 db for my app.