Skip site navigation (1) Skip section navigation (2)

Re: ResultSet performance question

From: Andres Ledesma <aledes(at)euskalnet(dot)net>
To: cservin(at)cromagnon(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSet performance question
Date: 2008-12-17 11:50:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hi Craig,

So, what I would do is :

1- create first a VIEW, to get the data out of the tables.
2- create a function that opens a CURSOR, based on the VIEW created in 
the step 1, and returns it
3- In my Java code, via a CallableStatement, get returned data as a 

That way you have some gains in time used parsing the query.



In response to

pgsql-jdbc by date

Next:From: JAlexoidDate: 2008-12-18 10:24:32
Subject: Re: ResultSet performance question
Previous:From: Andres LedesmaDate: 2008-12-17 10:20:56
Subject: Re: ResultSet performance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group