Tuesday, July 12, 2011

Mysql/PHP Idea

Just felt like posting a little idea I thought of to make databases smaller.

As in my notes:

To optimize databases use a single column per item.

Username | Password | sword_durability...etc

Use php code to decide the column state.

if (sword_durability == 1)
    // set sword durability as 1 (full)

elseif (sword durability == 0.9)
    // set sword durability as 0.9 (damaged a bit)

etc


Now this was just a simple idea i randomly came up with so it isn't very in depth. Thanks for reading this little idea. Feel free to share it.

No comments:

Post a Comment