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. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users