Page 1 of 1

MySQL Efficiency

Posted: Tue Dec 19, 2006 4:45 pm
by Entrophy
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

Posted: Tue Dec 19, 2006 4:49 pm
by Luke
that would depend on your game. Efficiency is a ratio of work over time. If you add tables that are unnecessary, of course it won't be efficient.

Posted: Tue Dec 19, 2006 4:50 pm
by feyd
I couldn't say which is more efficient without knowing a LOT more about the system, how it's built, and how you access it.

Posted: Tue Dec 19, 2006 4:51 pm
by Entrophy
It is a turn based mmorpg.

What do you need to know about my game (besides "everything")?

Posted: Tue Dec 19, 2006 4:58 pm
by feyd
.. 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.