Almost 2 times slower than chain with sorted about django-querysetsequence HOT 7 CLOSED

from itertools import chain
import random
import string
from time import time

from django.db.models.query import Q
from django.test import TestCase

from queryset_sequence import QuerySetSequence

from .models import (Article, Author, BlogPost, Book, OnlinePublisher,
                     PeriodicalPublisher, Publisher)


class TimeIt(object):
    def __enter__(self):
        self.time = time()

    def __exit__(self, *args):
        print(time() - self.time)


class TestPerformance(TestCase):
    def test_foo(self):
        """Set-up some data to be tested against."""
        alice = Author.objects.create(name="Alice")
        bob = Author.objects.create(name="Bob")

        mad_magazine = PeriodicalPublisher.objects.create(name="Mad Magazine")
        big_books = Publisher.objects.create(name="Big Books",
                                             address="123 Street")

        # Generate a bunch of books.
        for i in xrange(20000):
            N = 8
            title = ''.join(random.choice(string.ascii_uppercase + string.digits) for _ in range(N))
            author = random.choice([alice, bob])

            Article.objects.create(title=title, author=author, publisher=mad_magazine)
        for i in xrange(1000):
            N = 8
            title = ''.join(random.choice(string.ascii_uppercase + string.digits) for _ in range(N))
            author = random.choice([alice, bob])

            Book.objects.create(title=title, author=author, publisher=big_books, pages=random.randint(100, 100000))

        # Time this.
        print("CHAIN")
        for i in xrange(10):
            with TimeIt():
                data = sorted(
                    chain(
                        Article.objects.filter(Q(title__contains='Q') | Q(author__in=[alice, bob])),
                        Book.objects.filter(Q(pages__gt=1500))
                    ),
                    key=lambda instance: instance.title, reverse=True)

        print("QUERYSETSEQUENCE")
        for i in xrange(10):
            with TimeIt():
                new_data = QuerySetSequence(
                    Article.objects.filter(Q(title__contains='Q') | Q(author__in=[alice, bob])),
                    Book.objects.filter(Q(pages__gt=1500))
                ).order_by('-title')

from itertools import chain
import random
import string
from time import time

from django.db.models.query import Q
from django.test import TestCase

from queryset_sequence import QuerySetSequence
from lonje.account.models import User
from lonje.social.models import Feed, Like
from django.core.paginator import Paginator

class TimeIt(object):
    def __enter__(self):
        self.time = time()

    def __exit__(self, *args):
        print(time() - self.time)


class TestPerformance(TestCase):
    def setUp(self):
        """Set-up some data to be tested against."""
        a = User.objects.create(email='[email protected]', first_name="a", last_name="b")
        c = User.objects.create(email='[email protected]', first_name="c", last_name="d")

        print("Gen FEEDS")
        for i in xrange(20000):
            N = 8
            title = ''.join(random.choice(string.ascii_uppercase + string.digits) for _ in range(N))
            user = random.choice([a, c])

            Feed.objects.create(title=title, text=title, user=user)
            if i%1000==0:
                print i

        print("Gen Likes")
        for i, feed in enumerate(Feed.objects.all().order_by('?')[:1000]):
            user = random.choice([a, c])

            feed_list=user.feeds.all()
            Like.objects.create(user=user, feed=feed)
            if i%100==0:
                print i

    def test_foo(self):
        # Time this.
        print("CHAIN")
        for i in xrange(10):
            with TimeIt():
                data = sorted(
                    chain(
                      Feed.objects.all(),
                      Like.objects.all(),
                    ),
                    key=lambda instance: instance.date, reverse=True)
                p = Paginator(data, 20)

        print("QUERYSETSEQUENCE")
        for i in xrange(10):
            with TimeIt():
                data = QuerySetSequence(
                      Feed.objects.all(),
                      Like.objects.all(),
                ).order_by('-date')
                p = Paginator(data, 20)