... more stuff
at
php-app-engine.com

Sharding destroys the goals of your relational database

http://codemonkeyism.com/sharding-destroys-the-goals-of-your-relational-database/

There are at least three kinds of database read queries:

* Data graph building queries: With these you get your data out of the database, customers together with adresses etc.
* Aggregation queries: How many orders have been stored in the August, aggregated by product category
* Search queries: Give me all customers who live in New York

Sharding now does away with the second and third query and reduces databases to data storage.

Leave a Reply