Hi,
We are putting together a database which will utilise 22 character UIDs as the primary key on most tables. Has anyone done any tests to see if there is a significant performance penalty for using varchar as the datatype for the primary and foreign keys rather than char?
The data will be stored in Orcacle of MS SQL Server databases rather than VFP tables.
TIA
---------------------------
Mike Boulton
WST Pacific Pty Ltd
65 Henley Beach Road
Mile End, South Australia 5031
Tel: +61 8 8150 5500
Web:
www.wstpacific.com.au