[SQL-CVS] [ sqlobject-Patches-3601405 ] Use "insert ... returning id" with postgres
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: SourceForge.net <no...@so...> - 2013-01-18 18:39:04
|
Patches item #3601405, was opened at 2013-01-18 10:39 Message generated for change (Tracker Item Submitted) made by kenlalonde You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=3601405&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Ken Lalonde (kenlalonde) Assigned to: Nobody/Anonymous (nobody) Summary: Use "insert ... returning id" with postgres Initial Comment: When inserting records with driver postgres, it's faster to use the single statement "INSERT ... RETURNING id", rather than 2 statements -- one to get the current sequence value (and increment it), and another to do the insert. Patch is against SQLObject-1.2.4/sqlobject/postgres/pgconnection.py. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=3601405&group_id=74338 |