* FAQ    * Search  * Register * Login 
Active topics
Unanswered topics

All times are UTC-06:00



Post new topic  Reply to topic  [ 5 posts ] 
Author Message
 Post subject: database question
PostPosted: Sat Sep 17, 2011 11:55 am 
Offline
DBB Artist
DBB Artist
User avatar

Joined: Mon Aug 01, 2005 8:47 am
Posts: 7124
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝
I know with my pickle file databases I was very aware of my primary and foreign keys. This was because I ran in to problems, putting everything on one table would mean reading the whole file from top to bottom each time, which was slow. Also, hard to change. Breaking it up into different text files (tables) made it go faster.

In MySQL how necessary is dividing tables like this? Or is it ok to have everything about a comment box system loaded into one table? Mysql seems to be pretty well made for querying and returning only samples of data, like the last 5 comments associated with a comment box on a particular page.

Or is it always better to break up data into tables with relationships, even in MySQL?

_________________
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ


Top
   
 Post subject: Re: database question
PostPosted: Sat Sep 17, 2011 3:21 pm 
Offline
DBB Master
DBB Master
User avatar

Joined: Sun Sep 05, 1999 2:01 am
Posts: 6377
Location: ☃☃☃
You can google database normalization to get a theoretical treatment of this, but the high order bit is to create tables in order to avoid any data redundancy. And the primary appeal for this is correctness more so than performance. If you're storing the same data (that isn't being used as a key) in two different rows, then you're probably doing something wrong. You should split the redundant data off into a single row in a new table and use a foreign key to point to it from the original table.


Top
   
 Post subject: Re: database question
PostPosted: Sun Sep 25, 2011 11:13 am 
Offline
DBB Admiral
DBB Admiral

Joined: Wed Mar 24, 1999 3:01 am
Posts: 1121
I think it always better to break out all data relationships across many tables. They are called relational databases for a reason. I try to keep my main tables containing the bulk a given dataset to be predominantly integers referencing tables containing labels, etc...


Top
   
 Post subject: Re: database question
PostPosted: Sun Sep 25, 2011 2:49 pm 
Offline
DBB Artist
DBB Artist
User avatar

Joined: Mon Aug 01, 2005 8:47 am
Posts: 7124
Location: Ơ̸̦͇̲̬̭̱̰͎̞͈̣͎͚̳ͬ͋̃̀̇͊͂͋͐ͦ̽ͣ̂ͥ͊̅̀̚͠ B̶͖̯͉̜̰̲̓̔͋̈́ͅ È̯ Y̪̤̼͉̠̙͝
Oops forgot about this thread.

Jeff and Rev
here's what I figured I should do. It's pretty basic. Sorry if it's messy looking, I'm still playing with it.
Attachment:
database_Chatbox.png
database_Chatbox.png [ 61.66 KiB | Viewed 1045 times ]

_________________
s☼-£♦и̫͍ͥ̍ͪ͌̓͗͡о̡̹̱͊̅ͮ̓̕͢б̧̝̻̪̤̳̜͐̓̉ͤ͢͜ ͙̬͙̆̑ͮ̐ͭ̾̂́͘i̎̌̾̓̽̀̈̓̀҉͉̙̦͎̘̝͕f̻͕͔̘ͣͣ̓͊̿͢͜ ͍͔͈͕̮̫ͣ̆ͮ̊͋/♂6Æ!♪╩"▲L└уͭ̂͐̇҉̴̣̼̞̠̯͓̺̞ф̜̊͌̈́̋̏̐́ц̨͔̮̿̇ ̨̛͖̙͖̖̮̗̱ͩ̆͞ͅа̥͇̞̖͚̟̅͐ͤ͞͠͠э̜̘̩̳̬͔̾ͯ̀ͫ̒̐̿ͅͅг̭̖̀ͦ̒̑ͥ̌ͮͫ͞ё͔̟̃ͬ̾̓͟ё̦̞̙̫͔̩͑̀͂ͯ̄̔̃̑̀͠ͅͅ


Top
   
 Post subject: Re: database question
PostPosted: Sun Sep 25, 2011 3:14 pm 
Offline
DBB Admiral
DBB Admiral

Joined: Wed Mar 24, 1999 3:01 am
Posts: 1121
That's going in the right direction. :)


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC-06:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron



Descent'rs have piloted these pages
 
The layout and contents contained within this site are © DescentBB.net 1997-2006.
Descent, Descent II are © Parallax Software Corporation.
Descent III is Outrage Entertainment.
Descent is a Trademark of Interplay Productions.

Miner Wars™ is trademark of Keen Software House s. r. o.
.


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group