|
|
|
|
|
by jerrysievert
3342 days ago
|
|
simplicity, for one - write a quick query to retrieve all recipes that contain all of any number of ingredients. SELECT * FROM recipes r
INNER JOIN ingredients i ON (r.id = i.recipe_id)
WHERE i.ingredient IN ('mushrooms', 'sour cream')
load up some data and run explain analyze on both schemas/queries. |
|