Each query seems to execute a count() ?

[srtonz]

I noticed the following behavior when querying a simple model. Any idea why the count query is executed? When running the same query through a plain cassandra.cqlengine.models.Model outside of Django, I don't see the count query

x = list(Data.objects.filter(col5='27'))
[2017-06-21 14:04:41,692] [cassandra.cqlengine.connection] [DEBUG] [Connection: DEFAULT_CONNECTION] SELECT "col1", "col2", "col3", "col4" FROM fx.data WHERE "col5" = %(0)s LIMIT 10000 ALLOW FILTERING (pid: 6998)
[2017-06-21 14:04:42,872] [cassandra.cqlengine.connection] [DEBUG] [Connection: DEFAULT_CONNECTION] SELECT COUNT(*) FROM fx.data WHERE "col5" = %(0)s LIMIT 10000 ALLOW FILTERING (pid: 6998)

[srtonz]

I think this is because the _count attribute is reset here:

django-cassandra-engine/django_cassandra_engine/models/__init__.py

Line 675 in 140e12c

self._count = None

Not quite sure why that's happening instead of caching the queryset's count() result?

[srtonz]

Any ideas?

[r4fek]

Hey @geotob!

Sorry for the delay, I didn't have time to look into it.
Could you try with current master now?

[srtonz]

Hey @r4fek This works now, thanks a lot! 👍