View mysql on single table performance

Question

I have one tabular data warehouse with many integer, decimal, dated, varchar fields. I want to logically separate data in a data warehouse using the views on this table. so datastore.i1 becomes a view .field1 datastorei2 becomes a view .field2 etc ... There are indexes in the data store that provide a "key to the view".

Are there any implications for this approach?

Answer 1

Yes, there are performance issues in the course. This article may shed light on this issue - MySQL Performance Blog .

As a workaround, you can split the data into two physical tables (a one-to-one relationship).