So I am having problem with my site's performance so I consult my hosting what is the problem and they said this.
However, we see another 'slow' query, which
takes about a second
to complete and downloads the whole 'views' table
from the database for
some reason, with all the rows:
select * from views
It gets about half a million records, nearly every
second, and that
affects your site's performance negatively.
Also, it is
highly recommended to
use some caching in your script, and cache the
database query result,
rather than send the same 'slow' query frequently.
My DEVELOPER SAID
Using * is always a problem. Bcoz by using * you are actually giving MySQL work to find all tables first and then take the data. Instead of this best is .. If you want every table then better write SELECT rowname,rowname1,rowname2 FROM views
and I need to cache the database query result too