On 22 Jun 2014 at 10:08, Clemens Ladisch <clem...@ladisch.de> wrote: > Tim Streater wrote: >> I have a text column containing floating point strings like 23.6, 8.4, >> 0.3, etc. These always have just the one digit after the decimal point. >> >> ... ORDER BY ROUND (myfield, 1); >> >> but now I see I could just as well do: >> >> ... ORDER BY CAST (myfield AS REAL); >> >> Is the CAST likely to be significantly faster that the ROUND > > In my test, CAST is slightly faster. But who knows how it behaves on > your machine. > >> if the table is limited to say 20k rows? > > Then the difference is not noticeable.
Thanks, that answers two questions. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users