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
Date: Wed, 17 May 2006 14:00:01 -0500
Message-ID: <20060517190000.GU26212@pervasive.com> (raw)
In-Reply-To: <OFB3BF0469.CF0B4896-ON48257171.0020D175@pengroup.com.my>
References: <OFB3BF0469.CF0B4896-ON48257171.0020D175@pengroup.com.my>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, kah_hang_ang@toray.com.my, pgsql-jdbc@postgresql.org
Subject: Re: [PERFORM] Performance incorporate with JReport
In-Reply-To: <20060517190000.GU26212@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox