Thousands doesn't seem like it will be problem...so I'd keep it simple and put it in string form. You'll cut the bytes in half for a blob but it doesn't sound like you need it for just thousands unless you're really memory starved. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of George Sent: Mon 11/8/2010 11:24 AM To: sqlite-users@sqlite.org Subject: EXTERNAL:[sqlite] Best way to represent UUID Hi there. I'm wondering what the best way to represent a 16 byte UUID in sqlite might be (I didn't see any specific data type for UUIDs in the documentation, but forgive me if there is). I could just stringify or blob it, but I might have to index a large number of items by this identifier (thousands) , so speed is a consideration more than space would be. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users