<commit_before>from django.shortcuts import render

from twobuntu.articles.models import Article
from twobuntu.categories.models import Category
from twobuntu.decorators import canonical

@canonical(Category)
def view(request, category):
    """Display articles filed under the specified category."""
    return render(request, 'categories/view.html', {
        'title':    category.name,
        'articles': Article.objects.filter(category=category, status=Article.PUBLISHED),
    })<commit_msg>Added SQL optimizations to category index page, drastically reducing DB lookup time.<commit_after>from django.shortcuts import render

from twobuntu.articles.models import Article
from twobuntu.categories.models import Category
from twobuntu.decorators import canonical

@canonical(Category)
def view(request, category):
    """Display articles filed under the specified category."""
    return render(request, 'categories/view.html', {
        'title':    category.name,
        'articles': Article.objects.select_related('author', 'author__profile', 'category').filter(category=category, status=Article.PUBLISHED),
    })
{'fraction_non_alphanumeric': 0.10098302055406613, 'fraction_numerical': 0.0, 'mean_word_length': 5.222222222222222, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '898906', 'n_tokens_mistral': 299, 'n_tokens_neox': 269, 'n_words': 83}