#14700: Speed up RawQuerySet iterator
---------------------------------------------------+------------------------
Reporter: akaariai | Owner: nobody
Status: new | Milestone: 1.3
Component: Database layer (models, ORM) | Version: SVN
Resolution: | Keywords:
rawqueryset, iterator, performance
Stage: Unreviewed | Has_patch: 1
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Changes (by akaariai):
* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0
Comment:
Ok, some django-bench benchmark results:
{{{
query_raw: fetch 1000 objects with 11 fields.
Running 'query_raw' benchmark ...
Min: 0.070000 -> 0.010000: 7.0000x faster
Avg: 0.077600 -> 0.019200: 4.0417x faster
Significant (t=80.796194)
Stddev: 0.00431 -> 0.00274: 1.5742x smaller (N = 50)
query_raw_deferred: fetch 1000 objects having 11 fields, but get only the
pk from db
Running 'query_raw_deferred' benchmark ...
Min: 0.300000 -> 0.020000: 15.0000x faster
Avg: 0.305200 -> 0.020200: 15.1089x faster
Significant (t=358.775813)
Stddev: 0.00544 -> 0.00141: 3.8439x smaller (N = 50)
}}}
the attached tar.gz is the same as for #14697.
--
Ticket URL: <http://code.djangoproject.com/ticket/14700#comment:1>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
