I am developing a large database site. And expecting millions of data
and millions of user will visit site. As there are lots of dependent
tables so I need to create views for that or I can use Join Query.
Now main problem is that I am very confused regarding performance
issue of Views and Join query. There might be possible that there are
lots of complex join queries required to fetch result. So Can anyone
suggest me Which one is more efficient and faster in data fetching.
I am using MySQL as database.
Any help in welcome ...