Home > mailing lists

best performance for simple dml - Mailing list pgsql-sql

From	chester c young
Subject	best performance for simple dml
Date	June 27, 2011 06:30:03
Msg-id	333801.29762.qm@web161424.mail.bf1.yahoo.com Whole thread Raw
Responses	Re: best performance for simple dml (Pavel Stehule <pavel.stehule@gmail.com>)
List	pgsql-sql

what is the best performance / best practices for frequently-used simple dml, for example, an insert

1. fast-interface

2. prepared statement calling "insert ..." with binary parameters

3. prepared statement calling "myfunc(..." with binary parameters; myfunc takes its arguments and performs an insert using them

From: John Fabiani
Date: 23 June 2011, 16:46:09
Subject: Re: Union out performs the single statement

From: Pavel Stehule
Date: 27 June 2011, 06:36:06
Subject: Re: best performance for simple dml