On Wed, Mar 23, 2011 at 12:56 PM, Javier Guerra Giraldez <jav...@guerrag.com> wrote: > in this case the problem arises because of the big mismatch between > the forums_forum table (just 15 records) and the forums_topic table > (12k records) that, and the need to sort by a field on another > (bigger) table: forums_post.created_date
PS: i concur that 7secs for 12k records is pretty bad; definitely it's doing the sort on disk and seems to have be using a badly chosen set of memory parameters. still, optimizing the RAM usage for a bad case is a last resort. I'd first be sure that it's not possible to optimize the query and _only_then_ try to optimize RAM layout to soften the hit -- Javier -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.