Server database structure
#14

Quote:
Originally Posted by Vince
View Post
That entirely depends on what data you want to store. There's two catches: a) avoid duplicate data where possible and b) don't put numbers behind field names (weapon1, weapon2, etc), use another table instead.
You don't always have to normalizate your database to the full, that means, for example if you are going to have just 3 weapons max per player, you don't need a new table. Joins are not that cheap.

Its good to normalizate your database, and its also good to denormalizate it a bit and also allow some controlled redundancy if need.
Reply


Messages In This Thread
Server database structure. Share your database structure! - by dusk - 12.09.2014, 12:37
Re: Server database structure - by Vince - 13.09.2014, 10:19
Re: Server database structure - by RajatPawar - 13.09.2014, 10:31
Re: Server database structure - by iFarbod - 13.09.2014, 11:45
Re: Server database structure - by dusk - 13.09.2014, 13:39
Re: Server database structure - by IceCube! - 13.09.2014, 14:50
Re: Server database structure - by Pottus - 13.09.2014, 14:51
Re: Server database structure - by PowerPC603 - 24.02.2015, 10:40
Re: Server database structure - by Vince - 24.02.2015, 14:14
Re: Server database structure - by PowerPC603 - 24.02.2015, 14:32
Re: Server database structure - by Extremo - 24.02.2015, 15:13
Re: Server database structure - by PowerPC603 - 25.02.2015, 09:32
Re: Server database structure - by Luis- - 25.02.2015, 15:02
Respuesta: Re: Server database structure - by kirk - 25.02.2015, 16:41
Re: Server database structure - by PowerPC603 - 25.02.2015, 21:48

Forum Jump:


Users browsing this thread: 1 Guest(s)