Comment on How FriendFeed uses MySQL to store schema-less dataparentComments−finiteloop17yWe don't do any joins in MySQL. We query the indexes in all of the shards in parallel to get a list of entity IDs and then query the entities tables in all of the shards in paralel to get the entity bodies as a second operation.−gaius17yBut would you, if MySQL could do hash joins?
Comments
We don't do any joins in MySQL. We query the indexes in all of the shards in parallel to get a list of entity IDs and then query the entities tables in all of the shards in paralel to get the entity bodies as a second operation.
But would you, if MySQL could do hash joins?