[Resolved] MySql Database layout baded on uid

fr8

I was laying out my database and was wondering if i was doing it the most efficient way.

I have a user table that is 16 columns wide and I have come to a point where Im going to need to possibly triple the amount of stored data by adding more columns. So this table would be 48 columns wide.

The user table will be getting 10s of thousands of queries at any one time.

So what im wondering is if I should break the table up. Have say 5 items from it put into a different table that can be accesed by the uid. and it will only be hit on certain occations.

Or is mysql not even bothered if i use the select. so only select a few columns at a time during a query?

Roger_Ramjet

If you understood the relational database and how it works then you would not be asking this question.

Take the time to read some of these articles , especially this one on database design , and this one on database indexing

You should also read the manual on musql optimisation , especially the part about how mysql uses indexes.

fr8

Originally posted by Roger Ramjet
If you understood the relational database and how it works then you would not be asking this question.

ding ding. winner. 😃

Originally posted by Roger Ramjet
Take the time to read some of these articles , especially this one on database design , and this one on database indexing

You should also read the manual on musql optimisation , especially the part about how mysql uses indexes.

Damn good information. thanks. 🙂