Take the 2-minute tour ×

I have a single table datastore with loads of integer, decimal , date,varchar fields in. I want to logically separate the data in datastore by using a views over this table. so that datastore.i1 becomes view.field1 datastorei2 becomes view.field2 etc.... There are indexes in the datastore that provide the 'key to the view'.

Are there performance implications to this approach ?

share|improve this question
Without knowing a bit more about the shape of this table, I think it's hard to say what the right approach is. –  Strawberry Sep 13 '13 at 8:40
add comment

1 Answer

Yes, of cource there are performace issues. This article can shed the light on this problem - MySQL Performance Blog.

As a workaround - you could to split data into two physical tables (one-to-one relation).

share|improve this answer
add comment

Your Answer


