id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
5030	Remove COUNT(*) aggregate from model.save() when determining whether row exists	zigiDev@…	Adrian Holovaty	"Currently, the save method of the Model object uses an aggregate function to determine if a row with the specified primary key already exists.  However, we don't need to know the count just whether the row exists or not.  An alternative is to just simply SELECT 1 so if the row exists it will return 1, and if not we get a null. On PostgreSQL the COUNT(*) version takes over twice as long as the SELECT 1 version (''it's not that significant but it is unnecessary work''). Patch attached.

"		closed	Database layer (models, ORM)	dev		fixed	model save		Ready for checkin	1	0	0	0	0	0