| From: | Dave Cramer <Dave(at)micro-automation(dot)net> | 
|---|---|
| To: | Riyaz(at)umapinc(dot)com | 
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: [JDBC] Performance problem iterating a resultset | 
| Date: | 2002-10-18 14:34:26 | 
| Message-ID: | 1034951668.1866.26.camel@inspiron.cramers | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc | 
What else are you doing in the jsp, can we see the code?
Dave
On Fri, 2002-10-18 at 10:17, Riyaz(at)umapinc(dot)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 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-10-18 14:34:31 | Re: referential integrity violation | 
| Previous Message | mk | 2002-10-18 14:21:33 | referential integrity violation | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simpson, Mike W | 2002-10-18 15:40:03 | Re: [JDBC] Performance problem iterating a resultset | 
| Previous Message | Riyaz | 2002-10-18 14:17:56 | Performance problem iterating a resultset |