DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Performance issues regarding views vs tables?

Performance issues regarding views vs tables?

dgruskadgruska 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

  • allanallan Posts: 63,482Questions: 1Answers: 10,467 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.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.