goutomroy/medium_django_db_optimization_count_exist.py

## medium_django_db_optimization_count_exist.py

# Don't
count = len(Entry.objects.all())  # Evaluates the entire queryset

# Do
count = Entry.objects.count()  # Executes more efficient SQL to determine count

# Don't
qs = Entry.objects.all()
if qs:
   pass

# Do
qs = Entry.objects.exists()
if qs:
   pass

	# Don't
	count = len(Entry.objects.all()) # Evaluates the entire queryset

	# Do
	count = Entry.objects.count() # Executes more efficient SQL to determine count

	# Don't
	qs = Entry.objects.all()
	if qs:
	pass

	# Do
	qs = Entry.objects.exists()
	if qs:
	pass