[Answer]-Quantity of database query's vs application memory performance using Django

by

1👍

✅

Using SQL is the fastest method and will always beat the Python equivalent, even if it hits the database more. The difference is negligible in comparison. Remember, that’s what SQL is meant to do – be fast and efficient.

Anyway, running a thousand loops using timeit, these are the results:

In [8]: %timeit get_data1() # Using ORM
1000 loops, best of 3: 628 µs per loop

In [9]: %timeit get_data2() # Using python
1000 loops, best of 3: 1.54 ms per loop

As you can see, the first method takes 628 microseconds per loop, while the second one takes 1.54 milliseconds. That’s almost 2.5 times as much! A clear winner.

I used an SQLite database with only 100 objects in it (I used autofixture to spam the models). I’m guessing PostgreSQL will return different results, but I am still in favor of the first one.

👤yuvi

Leave a comment