Performance issues regarding views vs tables?
Performance issues regarding views vs tables?
![dgruska](https://secure.gravatar.com/avatar/c7e73a5d7a8052fe8d3852b9c2c6548e/?default=https%3A%2F%2Fvanillicon.com%2Fc7e73a5d7a8052fe8d3852b9c2c6548e_200.png&rating=g&size=120)
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