Page 2 of 2

Re: Dump MySQL array result?

Posted: Wed Oct 22, 2008 2:09 pm
by VladSun
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.