Data Calculations MySQL vs Python -


i'm trying understand of following better option:

  1. data calculation using python output of mysql query.
  2. perform calculations in query itself.

for example, query returns 20 rows 10 columns. in python, compute difference or division of of columns.

is better thing in query or in python ?

it matter of taste but...

... give exact opposite answer 1 alma mundo, (not so) simple calculation made on select ... clause, push toward using db "as calculator".

calculations (in select ... clause) performed last step while executing query. relevant data used @ point. "big job" has been done (processing join, clauses, aggregates, sort).

at point, load of performing arithmetic operations on data small. , reduce network traffic between application , db server.

it matter of taste thought...


Comments

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -