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: 4948E79C.7050005@euskalnet.net (view raw or flat)
Thread:
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 
ResultSet

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

Regards,

Andrés




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-2014 The PostgreSQL Global Development Group