Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
06-09-2014, 09:46 PM #1
- Join Date
- May 2014
- Thanked 0 Times in 0 Posts
How to build best database as possible?
Question about database.
How I can build best/ fastest database as possible for browser game?
Is there any "rules" or important steps which I should know?
I made some searches from google and found: Database Normalization
Ill keep reading from other sources where I can find info, but if someone could share
his/ her knowledge, I would love that.
06-09-2014, 11:52 PM #2
- Join Date
- Sep 2005
- Sydney, Australia
- Thanked 779 Times in 768 Posts
A fully normalised database is fastest for inserting and updating data in the database as all of the information is stored the minimum number of times needed to identify all of the relationships.
That should alweays be your starting point with the database design.
Where this does not produce fast enough processing times the next thing to look at is indexes. Often adding or removing indexes on one or more tables will influence how quickly the relevant data can be accessed.
Only where the fully normalised database with optimised indexes is still too slow should you then look at undoing some of the normalisations where the data is read far more frequently than it is written. Note that each time you undo a normalisation you create a situation where the same data is stored more than once and open up the possibility that the two places will not have the same value stored in them leading to inconsistencies so you should only ever do this for data that is relatively static but which is frequently read.
Users who have thanked felgall for this post: