Re: Performance problem iterating a resultset

Hi Riyaz,
One option would be to write a stored function and invoke it from your jsp
page. This way you dont have
to do the resultset iteration in the client.

Thanks,
Nagarajan.

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Riyaz(at)umapinc(dot)com
Sent: Friday, October 18, 2002 4:18 PM
To: pgsql-jdbc(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
Subject: [JDBC] Performance problem iterating a resultset

Hello,
I am using JDBC driver for Postgresql to retrieve results from a JSP
page, iterating through the resultset to extract the results and
concatenating it to a string. Everthing is working except for that while I
am iterating through the resultset to generate a string its taking a good
amount of time. Is there a way in Postgresql where I can export the
resultset directly to a xml file?(The data I am receiving from the database
are xml nodes)

Or, Is there a faster way I can retrieve results from the resultset?

Thanks,
-Riyaz