Performance issues regarding views vs tables?

Performance issues regarding views vs tables?

dgruskadgruska Posts: 27Questions: 8Answers: 0

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

  • allanallan Posts: 61,627Questions: 1Answers: 10,091 Site admin

    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

Sign In or Register to comment.