以下三种执行方式的速度/性能排列是怎么样的,请分析:
suppose we have a model named Bicycle and we want to get bicycles which belongs to lockey23. Firstly, we have some code as below:
my_bicycles = Bicycle.objects.filter(username = 'lockey23')
then, there are three ways to get and display the number, but which has the best performance?
1. my_bicycles.count()
2. len(my_bicycles)
3. {{ my_bicycles|length }}
if not has an answer in mind, please see below from official document:
That is, the database can typically do things faster than Python can, which can do them faster than the template language can:
# QuerySet operation on the database
# fast, because that's what databases are good at
my_bicycles.count()
# counting Python objects
# slower, because it requires a database query anyway, and processing
# of the Python objects
len(my_bicycles)
# Django template filter
# slower still, because it will have to count them in Python anyway,
# and because of template language overheads
{{ my_bicycles|length }}
“`