Hi there, I need a simple question answered: If you are running a game, with two tables ( table1 contains user info, table2 containers resources, soldiers, etc ), does it run more efficiently for users rather than if you were using multiple tables such as: table1 = user info, table2 = resources, table3 = soldiers, table4 = weapons etc etc ?
Thanks
MySQL Efficiency
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
.. a little of this, a little of that .. The bullet points I've listed would be a starting place.
The answer in the end will mostly come down to how efficiently you've designed it to work, whether it's normalized to help you, denormalized to help you, and all the fun parts in between like indexes, field types, choices you've done in coding.. the whole gamut pretty much.
The answer in the end will mostly come down to how efficiently you've designed it to work, whether it's normalized to help you, denormalized to help you, and all the fun parts in between like indexes, field types, choices you've done in coding.. the whole gamut pretty much.