0

Which option is better for table design

Please suggest which options is better 
1> Single table with 300K records 
4> 40 tables with 20-30 records each

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Option 1 ( Single table with 300K records )is better for the following:
    1- Maintaining SQL queries or table structure for 1 will be much easier than 40 .
    2- Performance will be better as it will be no need to calculate too much joins between 40 tables.
     

    Reply Like
Like Follow
  • 8 mths agoLast active
  • 1Replies
  • 32Views
  • 1 Following