#5030: Remove COUNT(*) aggregate from model.save() when determining whether row
exists
-------------------------------+--------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: adrian
Status: new | Component: Database wrapper
Version: SVN | Resolution:
Keywords: model save | Stage: Ready for checkin
Has_patch: 1 | Needs_docs: 0
Needs_tests: 0 | Needs_better_patch: 0
-------------------------------+--------------------------------------------
Changes (by Simon G. <[EMAIL PROTECTED]>):
* stage: Accepted => Ready for checkin
Comment:
Commenters to the above thread show that the SELECT 1 does work on Oracle
and SQL Server and is more efficient. I've check the explain plans under
SQlite and MySQL (both InnoDB and MyISAM tables) and SELECT 1 is more
efficient on SQLite and exactly the same in MySQL.
--
Ticket URL: <http://code.djangoproject.com/ticket/5030#comment:8>
Django Code <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
-~----------~----~----~----~------~----~------~--~---
