Re: [arch-general] [PATCH] Drastically reduce loading time of Todo lists

On Mon, Jan 25, 2010 at 11:03 PM, Evangelos Foutras <foutrelis@gmail.com> wrote:

Use Django's select_related() on the TodolistPkg QuerySet to avoid making 4 database queries per package. This way we're making just one query, regardless of the number of packages in the Todo list.

Local testing with 1000 entries in a Todo list show that the loading time has been reduced from 2675 ms to around 560 ms, while the number of queries has been cut down from 8005, to only 5. ---  main/models.py |    2 +-  1 files changed, 1 insertions(+), 1 deletions(-)

Thanks! This is a huge improvement. -Dan