Hacker News new | past | comments | ask | show | jobs | submit login

You should definitely bench your storage to confirm that it likes hotspots (some don't!)



You should, but B-tree is the most common data structure used for database indexes, and sequential order performs better than random order for index keys.


You often can't bottleneck the entire workload on the capacity of one cluster node and one storage device.


I can't really understand what you said, could you elaborate? :)


If one machine can only handle a hundred transactions per second, and you might ever receive more than that, you have to spread the work across several machines, probably by assigning primary keys that aren't (mostly) sequential.


usually in sharding schemes its a few bits of a hash of the id that are used to determine shard; the system or library you are using will take care of this transparently for you.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: