Should I use a MySQL table in which all fields are of type TEXT NULL, and will it be retrieved using LIMIT? Will it affect performance?
There is a certain aggregating result of the sample, and the processing of this result takes some time, during which it is highly undesirable to change this selected data. I plan to save the entire result in a temporary table for further processing.
The problem is that the result is different, due to the dynamically generated fields in this result. I create a list of fields based on the first line of the result. Determining the types for each field does not work correctly, because it is not possible to determine the type precisely based on a single line.