Changes between Initial Version and Version 1 of Ticket #31202, comment 3


Ignore:
Timestamp:
Jan 23, 2020, 11:07:04 AM (4 years ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #31202, comment 3

    initial v1  
    1 From looking at the profiles the performance boost is likely due to the fact Django uses `Case`, `When`, and `Value` expressions that needs to be resolved [https://github.com/aykut/django-bulk-update/blob/399e64d820133a79f910682c1cf247938c5c4784/django_bulk_update/helper.py instead of raw SQL like the third party package does].
     1From looking at the profiles the performance issue is likely due to the fact Django uses `Case`, `When`, and `Value` expressions that needs to be resolved [https://github.com/aykut/django-bulk-update/blob/399e64d820133a79f910682c1cf247938c5c4784/django_bulk_update/helper.py instead of raw SQL like the third party package does].
    22
    33I suspect using `RawSQL` with `CASE`/`WHEN` SQL templates instead of `Case`/`When` expressions would significantly speed up the current implementation.
Back to Top