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

[Dan McGee]

On Mon, Jan 25, 2010 at 11:03 PM, Evangelos Foutras <foutrelis at 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