K
K
Kripto772017-10-06 09:47:42
MySQL
Kripto77, 2017-10-06 09:47:42

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

1 answer(s)
B
Boris Korobkov, 2017-10-06
@BorisKorobkov

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 question

Ask a Question

731 491 924 answers to any question