Re: [PERFORM] Performance incorporate with JReport

Moving to -jdbc.

On Wed, May 17, 2006 at 02:13:46PM +0800, kah_hang_ang(at)toray(dot)com(dot)my wrote:
> Currently I'm using postgresql v8.1.3 and the latest jdbc.
>
> I try to open a JReports' report and the time taken to completely open the
> report is 137453ms.
> Then I open the same report but this time I connect to postgresql v7.2.2
> but the completion time is even faster than connect to postgresql v8.1.3
> which took 15516ms to finish.
>
> I try many times and the result is still the same.
>
> So I think it might be compatibility problem between JReport & Postgresql
> 8.1.3 so i add in 'protocolVersion=2' in the connection string.
> Then i open the same report again and this time it just as what i expected,
> the execution time for the report become 6000ms only,
> it is 20x times faster than previous test without 'protocolVersion=2'
> option.
>
> May I know what is the reason of this?
> Is it because of the compatibility between JDBC driver with JReport?

This certainly sounds like a likely JDBC issue, so I'm moving this email
to pgsql-jdbc, since someone there is more likely to be able to help
you.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461