I have a table in my MySQL 5.7 database, which has 9 columns. One column is an
AUTO INCREMENT PRIMARY KEY, where as the other 6 contain some data, which isn't going to be updated in a year. Now, the last 2 columns are of type
JSON and they are going to be updated frequently, multiple times in a second(could be 5 times a second, and as system scales could be much more than that).
My question is, should i split my table into 2 tables, having a one to one relationship? So that all the non changing data goes in one table and the 2 columns which are to be updated frequently go to the other table.