Answer the question
In order to leave comments, you need to log in
Which sample is faster - by float or decimal?
The table has 370k rows and continues to grow. Previously, there were INT and there were no questions. Now we need fractional numbers.
Time DECIMAL a line - on idea sampling not fast.
In FLOAT, as far as I understand, there are problems with direct comparison of the WHERE square="1.7" type.
Advise in which type of field it is better to store fractional numbers (up to 3 decimal places) for the fastest selection by range and direct comparison.
Answer the question
In order to leave comments, you need to log in
https://dev.mysql.com/doc/refman/5.7/en/choosing-t...
https://dev.mysql.com/doc/refman/5.7/en/storage-re...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question