Performance issues regarding views vs tables?
Performance issues regarding views vs tables?
dgruska
Posts: 27Questions: 8Answers: 0
in SearchPanes
Hello,
My team and I have been using server-side searchpanes with node and mySQL. We are seeing a significant drop in performance when using a view for the data vs using a static table. Any computations done on the SQL end further decreases performance. Is there a way to remedy this?
Answers
It 100% depends what the VIEW is doing. Take the SQL statement it is running and use
EXPLAIN
on it to see what is taking the time in the query.Allan