#9519: QuerySet.delete() should operate with respect to previous query
operations
---------------------------------------------------+------------------------
Reporter: Tarken | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version: 1.0
Resolution: | Keywords: database,
queryset, delete
Stage: Design decision needed | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Changes (by tobias):
* cc: tobias (added)
Comment:
This is an issue for me as well. Imagine the cycle:
1) SELECT 100 of the objects you want to delete (this can take awhile
depending on the WHERE clause)
2) DELETE those objects by ID
Now imagine it repeated 10000 times. I'm trying to delete millions of
rows from a table, so the current way .delete() works is completely
unusable.
IMHO .delete should just use the FROM table, JOINs (if any), and WHERE
clause from the queryset itself.
--
Ticket URL: <http://code.djangoproject.com/ticket/9519#comment:2>
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
