Re: How not to use JDBC (JDBC Performance Scale 15x presentation)

Dave,

I’ve tested both alternatives: setting within JDBC url and with <connection-properties> and both seem to work

But the documentation Christian Bjørnbak pointed to (https://jdbc.postgresql.org/documentation/94/connect.html) states

„The default is zero, meaning that in ResultSet will be fetch all rows at once“

So doing nothing should lead to maximum performance.

Stefan

Von: davecramer(at)gmail(dot)com [mailto:davecramer(at)gmail(dot)com] Im Auftrag von Dave Cramer
Gesendet: Donnerstag, 16. März 2017 01:11
An: Stefan Lindner
Cc: List
Betreff: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)

Stefan,

Reading the docs, there is something called connection-property that I would expect to be passed to the driver.

· <connection-property> - used to configure the connections retrieved from the java.sql.Driver, e.g.

<connection-property name="char.encoding">UTF-8</connection-property>

Let me know if that works and I'll update the docs

Dave

Dave Cramer

davec(at)postgresintl(dot)com<mailto:davec(at)postgresintl(dot)com>
www.postgresintl.com<http://www.postgresintl.com>

On 15 March 2017 at 18:29, Stefan Lindner <stefan(dot)lindner(at)visionet(dot)de<mailto:stefan(dot)lindner(at)visionet(dot)de>> wrote:
Dear Dave,

how can we control FetchSize in a XML-Style DatasourceDefinition e.g. for Wildfly?

Stefan

Von: pgsql-jdbc-owner(at)postgresql(dot)org<mailto:pgsql-jdbc-owner(at)postgresql(dot)org> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org<mailto:pgsql-jdbc-owner(at)postgresql(dot)org>] Im Auftrag von Dave Cramer
Gesendet: Mittwoch, 15. März 2017 22:35
An: Jorge Solórzano
Cc: Vladimir Sitnikov; List
Betreff: Re: [JDBC] How not to use JDBC (JDBC Performance Scale 15x presentation)

please provide feedback, I'm giving the same talk at pgconf in nyc

Dave Cramer

davec(at)postgresintl(dot)com<mailto:davec(at)postgresintl(dot)com>
www.postgresintl.com<http://www.postgresintl.com>

On 15 March 2017 at 17:29, Jorge Solórzano <jorsol(at)gmail(dot)com<mailto:jorsol(at)gmail(dot)com>> wrote:
https://github.com/davecramer/presentations

Jorge Solórzano

On Wed, Mar 15, 2017 at 3:25 PM, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com<mailto:sitnikov(dot)vladimir(at)gmail(dot)com>> wrote:
Is the presentation available online somewhere?

Vladimir