Hi,
I'm not really sure how possible it would be, but a kinda perfect hash function I think should exist that translated autoincrement values to pseudo random so they get distributed into different ranges when primary key is `(id autoincrement)` ? I mostly care the `id` to be small (64bit integer) + unique + random distributed.
Another way would be to prefix the primary-key with (hash(id), id) but this will make primary keys larger.
Any ideas ?
Regards,
ddorian43