which is better, creating a view or a new table?

Posted by Carson on Stack Overflow See other posts from Stack Overflow or by Carson
Published on 2010-05-24T23:51:19Z Indexed on 2010/05/25 0:01 UTC
Read the original article Hit count: 176

I have some demanding mysql queries that are needed to grap same datasets from several mysql tables.

I am thinking of creating a table or view to gather all demanding columns from other tables, so as to increase performance.

If I create that table, I may need to do extra insert / update / delete operation each time other tables updated.

if I create view, I am worrying if the performance can be greatly improved. Because data from other tables are changing very frequently. Most likely, the view may need to be created first everytime before selecting it.

Any ideas? e.g. how to cache? other extra measures I can do?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database-design