#34580: Performance regession in SQLCompiler
-------------------------------------+-------------------------------------
Reporter: David Smith | Owner: nobody
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by David Smith):
I attempted to see if the benchmark workflow could detect the changes from
the propose patch in [https://github.com/django/django/pull/16882 PR ].
Unfortunately it could not.
However, running locally I can see a performance improvement in the region
of 20-30% from the proposed change. I was able to repeat this, and see a
similar improvement a second time.
{{{
before after ratio
[ca5d3c99] [2aa6996a]
<form_docs> <SQLCompiler>
- 1.83±0.01ms 1.41±0.01ms 0.77
query_benchmarks.query_exists.benchmark.QueryExists.time_query_exists
- 874±2μs 621±8μs 0.71
query_benchmarks.query_aggregate.benchmark.QueryAggr.time_aggregate
- 1.35±0.02ms 905±4μs 0.67
query_benchmarks.query_count.benchmark.QueryCount.time_query_count
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/34580#comment:2>
Django <https://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 unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/010701883f3f3559-e715ff37-2f7e-4b49-84fb-3da1ad425d20-000000%40eu-central-1.amazonses.com.
