CODEWITHSUNDEEP
mysqlperformance
neotam
neotam

Reputation: 2731

Creating number of small small table or creating a very large table, which way is recommended in mysql

I have query regarding the performance of MySQL, that is

I have the mysql table with more than 60 columns now I have a requirement to add many more columns to that table. I am always bothering about performance. So can you please tell me any body which way is best way. That is either creating the large table or creating a number of small small tables.

Upvotes: 1

Views: 74

Answers (2)

mithuna kous
mithuna kous

Reputation: 329

small tables are best in performance and easy to recover the data. so i am suggesting you can go for small tables and create relationship between them like primary key and foreign key or delete or update cascade as per your requirement.Always adding multiple columns to a table impact on your DB performance.

Upvotes: 1

TNK
TNK

Reputation: 4323

Never use long flat table. Divide it into separate table. you need to learn how to design database. Just search google 'data normalization'

Upvotes: 0

Related Questions