There’s no reason for a human to want to sort by GUID. They’re arbitrary symbols and don’t have an order. Anyone who says "Show me our spare parts in GUID order." needs to rethink why they’re doing what they’re doing.
However, SQLite does searching by sorting. Binary chop is still the best way we know to find one value of many (though hashes look interesting), and for that you need your values in sorted order. So yes, you’re going to sort by your key values. The other thing is that your primary key should be values which don’t matter to you. Because if you care about a value sooner or later you’re going to think of a reason to change it. So if you understand UUID, appreciate their structure, print them out, or use parts of them to indicate factories or data-sources, they’re significant values and you need something else to use as a primary key. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
