Jump to content
Sign in to follow this  
Angeleyezz

Designed DB for performance

Recommended Posts

I am putting together a table that has user information.  basic info, name, address, tele, account status, etc.  My question is should I keep all of that in a seperate table and just relation to it through an account ID, and only pull the data when I need it from the other table?  or will that end up making more processes for the server every time it needs the info it has to pull data from 2 tables instead of 1 table with lots of fields?

Share this post


Link to post
Share on other sites

Your answer lies in understanding "Database Normalization". Look it up and learn it well. It will always be important to know when designing databases.

Share this post


Link to post
Share on other sites

Yes, database normalization is what you want to check into. It is where you set up your database by organizing it to reduce data repetition. It is primarily designed to improve the data integrity, but can be used to optimize its efficiency too.

Share this post


Link to post
Share on other sites

Ahh normalization, I knew there was a term for it, just couldnt remember what it was.  Thanks guys!!!! been a long time since i've worked with any of this, but I'm just getting back into it.

Share this post


Link to post
Share on other sites

Your original post sounds like you want to artificially split your original table into many small tables, so that the database system doesn't have to "deal with all data at once". Don't do that. Modern database systems are a lot smarter than you seem to think and only load the data which is actually used. Besides that, even gigantic tables with hundreds of columns and millions of rows are no problem at all -- I'm sure you have less than that. So there is absolutely no need to "keep tables small". In fact, this is counter-productive and will likely lead to a total mess.

 

What you should take care of is correctness, not your naive understanding of "performance".

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.