Performance problem iterating a resultset - Mailing list pgsql-jdbc

From Riyaz@umapinc.com
Subject Performance problem iterating a resultset
Date
Msg-id OFAC5D2800.ADCB89A9-ON05256C56.004DC6E8-85256C56.0048F164@umapinc.com
Whole thread Raw
Responses Re: Performance problem iterating a resultset  ("G.Nagarajan" <gnagarajan@dkf.de>)
Re: Performance problem iterating a resultset  (Dave Cramer <Dave@micro-automation.net>)
Re: Performance problem iterating a resultset  (Teofilis Martisius <teo@teohome.lzua.lt>)
List pgsql-jdbc

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  

pgsql-jdbc by date:

Previous
From: lalit
Date:
Subject: Re: Support for javax.sql.DataSource ..
Next
From: "G.Nagarajan"
Date:
Subject: Re: Performance problem iterating a resultset