On 2018/01/08 11:17 AM, Shane Dev wrote:
P.S one reason I am using SQL instead the main application to perform such
calculations is precisely to avoid using variables (and hence the evils of
mutable state). Why do you say it is more efficient?
Because it is much more efficient, memory used in stead of computations
through the DB engine. It's even vastly more efficient when you do these
things in your programming language (Zero parsing to start with)...
That however doesn't mean you should only do it this way. There are
obviously merits (such as mutable state evility, if there is such a
word) to using a less efficient method.
sqlite-users mailing list