Re: Django Transactions Performance increase

2013-10-29 Thread Apostolos Bessas
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

Re: Complex query reduction

2013-11-04 Thread Apostolos Bessas
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