Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Performance incorporate with JReport






Hi,

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?

Thanks!




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group