Due to technical reasons, the implementation must use view

View query conditions do not add tasks, seconds,
Added a condition to 3 minutes,
Add the where clause condition, is a text view, do not make any calculations,

What optimization scheme?

Data volume was about 2 w,

CodePudding user response:

Not only is this field, add any conditions, is very slow

CodePudding user response:

Conditions and the transformation, before is 08, converted into 8. Speed is good,

Check now but the key select count (1) the from view the where condition=8, also want a minute, what reason is this