Re: Dump MySQL array result?
Posted: Wed Oct 22, 2008 2:09 pm
A few things:
- you are using varchar column (category_id, game_id) in game_category for referencing an int columns - don't do this
;
- you don't need the surrogate key id in game_category - the game_id and category_id, together, are the natural key for such type of tables;
- you don't have any indexes created on category_id, game_id.
- you are using varchar column (category_id, game_id) in game_category for referencing an int columns - don't do this
- you don't need the surrogate key id in game_category - the game_id and category_id, together, are the natural key for such type of tables;
- you don't have any indexes created on category_id, game_id.