Hello,
i'm just thinking about different type of Primary Keys. We're actually using randomly generated UUIDs (GUIDs) for our "billons-of"-tables. They're stored in VARCHAR(50)-Columns and hence tend to bloat space-consumption. Further i'm *guessing* they're not quite well-performing concerning bulk-insert and large queries. How appropriate do you consider DEFAULT SERIAL for such large tables (containing, or going to contain billions of records)?
Are they're any other viable possibility for automatic created primary keys? Thanks alot. :-) Flo -- Florian Schmitz ______________________ acardo technologies AG Königswall 18a 44137 Dortmund fon: +49 (0) 2 31 / 58 44 97 - 0 fax: +49 (0) 2 31 / 58 44 97 - 21 mail: [EMAIL PROTECTED] web: www.acardo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
