Date: Wed, 17 May 2006 14:00:01 -0500
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: kah_hang_ang@toray.com.my
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [PERFORM] Performance incorporate with JReport
Message-ID: <20060517190000.GU26212@pervasive.com>
References: <OFB3BF0469.CF0B4896-ON48257171.0020D175@pengroup.com.my>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <OFB3BF0469.CF0B4896-ON48257171.0020D175@pengroup.com.my>
User-Agent: Mutt/1.5.11

Moving to -jdbc.

On Wed, May 17, 2006 at 02:13:46PM +0800, kah_hang_ang@toray.com.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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461