StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POOptimizing django DB access when you perform multiple filters different times on one base QuerySet that filtered daterange
text
Body
copied!<p>I have a view that does something like this:</p> <pre><code>objectBase = MyModel.objects.filter(startDate__range=(start,end)) automatedObjects = objectBase.filter(automated = True).count() userCreatedObjects = objectBase.filter(userCreated = True).count() bookObjects = objectBase.filter(subClass = 'book').count() pageObjects = objectBase.filter(subClass = 'page').count() allObjectsCount = objectBase.count() </code></pre> <p>I am using 1.2.4 and the latest postgres</p> <p>Anyways, I have about 20 different ways I need to filter my objectBase that filtered by date, and I noticed that each SQL query filters by date. Is there a more efficient way to make the subsequent queries not have to filter by date? Would there be a speed difference? </p> <p>Also what do you think would be the best method for caching the objectBase query since theoretically it could hold hundreds or thousands of objects for the dates filtered and the likely hood of the start, end dates being the same for a request is very unlikely. </p> <p>like say somebody could request the stats between dates t1 and t2, and then later request t3 to t4 where t1 < t3 < t2 and t2 < t4 so there is some overlap. Is there a way to cache it so where there is overlap between the requests that it would have to access the db for it?</p> <p>sorry if this seems like a hefty request, but any help would be appreciated. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload