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