Hello! I did find interesting article about this popular question http://blog.maxindelicato.com/2008/12/how-to-organize-a-database-tables-keys-for-scalability.html
I would also like to add that SQLite supports "attach" command due to which we are able to use a lot of database shards on a single machine without using a lot of memory. I did create ticket "GUID primary keys" and think it's may be very good feature: http://www.sqlite.org/cvstrac/tktview?tn=3557 Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
