C
C
CreativeStory2019-01-16 20:23:42
MySQL
CreativeStory, 2019-01-16 20:23:42

Database query optimization how to do?

When creating a site page in the admin panel, a request is made to the database, which displays a lot of options on the page in the admin panel (see screenshot).
Each option has 4 variables, each has 2 states (active / not) checkboxes. There are a lot of options and all are displayed when forming a post on the site. How can this query be optimized?
In fact, you need to check the column in the request - To the package, if it is active, then send the next request according to the status of other checkboxes of this option. And how can you remember the active state of the checkbox, so that when you subsequently edit the page, the query to the database goes only through active checkboxes?
What solution can you come up with for optimization?
5c3f6821cf7ba393773024.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
grinat, 2019-01-16
@grinat

www.mysql.ru/docs/man/EXPLAIN.html

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question