Hello Max, Your link is pretty interesting. It looks that : - method1 should be easily implemented with SQLite "floating point" representation, - and with a very very small code size.
Here is the benchmarking of the two available methods : https://raw.github.com/stonebig/ztest_donotuse/master/square_rooting_benchmark.GIF So : - your method is only 3 times slower than the python sqrt(), - if SQLite team accepts to sacrifice a few bytes to implement sqrt(), we may benefit a 389% speed-up (300/27*.652/1.86) at least. (300/27*.652/1.86) sqrt() is very interesting for statistics on-the-go over sql datas. Regards, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
