Hola, In an inventory system, I've got a PartNumber model and a Buckets model - each bucket holding one or more instances of a part number.
Each instance can have a separate price and currency - depending on date and supplier these can fluctuate. >From this data we would like to extract total and average value, per currency, per PartNumber. The problem is that even with a relatively small number of parts (<5000) and only 4 currencies (USD, AUD, EUR, GBP) we are seeing page rendering slow down as each of those queries is sent off to be worked out. Caveat: The desire is for the page to list *all* parts, not a subset. I've implemented solr/haystack for individual search, but sometimes they want the overview. I watched Andrew Godwin's presentation on Rapid Schema Development http://vimeo.com/83756644 and thought that maybe what I need to do is implement a small function within PostgreSQL rather than within my view? Another solution that had occurred to me was to have a PostgreSQL view that was updated on Bucket insert to hold the total and average value data. ( I read this post about django-postgres http://blog.isotoma.com/2014/05/a-different-view-part-2/ ) Is there a preferred method, or a recommended solution? cheers L. -- The idea is that a beautiful image is frameable. Everything you need to see is there: It’s everything you want, and it’s very pleasing because there’s no extra information that you don’t get to see. Everything’s in a nice package for you. But sublime art is unframeable: It’s an image or idea that implies that there’s a bigger image or idea that you can’t see: You’re only getting to look at a fraction of it, and in that way it’s both beautiful and scary, because it’s reminding you that there’s more that you don’t have access to. It’s now sort of left the piece itself and it’s become your own invention, so it’s personal as well as being scary as well as being beautiful, which is what I really like about art like that. ----------------------------------------------------------------------------------------------------------- Adventure Time http://theholenearthecenteroftheworld.com/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGBeqiOnJ3EfocsODLzsDd1aD-wf%3Dx171Q5iEtaVhn4VyPLwpQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
