Hi Robin,
As far as I can tell, using one transaction should increase the
performance of the process. The reason is that you issue just one
COMMIT for the whole process instead of one per UPDATE. As an added
benefit, it helps with the data integrity.
There are two main ways I know you can improve
On Sat, Nov 2, 2013 at 4:50 PM, Daniele Procida wrote:
>
> But, the real killer is the combination of ordering (in the queryset or on
> the model, it doesn't matter) with the distinct() - as soon as one is removed
> from the equation, the execution time drops to around 250ms.
>
> That's for 5500
2 matches
Mail list logo