Thread: Performance problem iterating a resultset

Performance problem iterating a resultset

From
Riyaz@umapinc.com
Date:

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  

Re: [JDBC] Performance problem iterating a resultset

From
Dave Cramer
Date:
What else are you doing in the jsp, can we see the code?

Dave
On Fri, 2002-10-18 at 10:17, Riyaz@umapinc.com wrote:
> 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