I have a
users table that contains users' information and a column named
credits that is frequently updated.
On index page I'm showing list of users with basic user information but I don't need credits.
On details page I'm also showing credits with user information.
Two main operations are dense in project. The first operation is the
SELECT operation on index page. The second operation is the
UPDATE operation on credits column.
credits column is not indexed but since it's frequently updated, will it effect the indexed columns on
users table? If so, I think I should separate
credits column as a table and join it only when required. Doing by this, can I improve
SELECT performance on index page?
Also, I'm using MySQL. What kind of table structure should I use for frequently updated columns?