On Wed, Jan 27, 2016 at 6:24 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
<snip>
Parameter passing and variables are client-side considerations. You haven't told us how you plan to execute the SQL.IMO the most straight-forward API is a function. Whether you implement that function using a updating CTE or a sequence of separate SQL commands is up to you to decide and, if performance matters, benchmark.Comparing a CTE and function in general doesn't really do much good. There are many non-performance concerns involved and the specific usage pattern involved will matter greatly in determining overhead.
Thanks David, that makes sense. My main front-end - at the moment - is LibreOffice Base. With Base, I can probably just create forms using the underlying tables. That said, I may also want to write a Python front-end, in which case I would prefer to let the database do the work it was designed to do.
Don
-- D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
Minister, Security/FM Coordinator, Free Software Advocate
GPG Key ID: F5E179BE
