A
A
abylalikkkk2022-03-16 14:21:23
SQL
abylalikkkk, 2022-03-16 14:21:23

Is it normal to do UNION 8 times) will it generally affect the speed?

Is it normal to do UNION 8 times) does it affect the speed at all?
And is it possible to specify one WHERE for all unions, since the field is the same.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
F
FanatPHP, 2022-03-16
@abylalikkkk

No, it's not normal. Already one union is most likely govnokod and and curve structure of a DB.
The speed is affected not by some particularly dangerous operators, but by the enumeration of large amounts of data without an index.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question