MySQL Efficiency

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Entrophy
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 5:47 pm

MySQL Efficiency

Post 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
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
Entrophy
Forum Newbie
Posts: 4
Joined: Tue Mar 21, 2006 5:47 pm

Post by Entrophy »

It is a turn based mmorpg.

What do you need to know about my game (besides "everything")?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
Post Reply