PostgreSQL performance through Plugin/JDBC
PostgreSQL performance through Plugin/JDBC
- Subject: PostgreSQL performance through Plugin/JDBC
- From: Guido Neitzer <email@hidden>
- Date: Mon, 29 Aug 2005 16:47:37 +0200
Hi.
Has someone experiences here what may be wrong, when I get poor
performance results when using PostgreSQL with WebObjects?
My configuration is:
- WebObjects 5.3 or 5.2.4 (same results)
- PostgreSQL 8.0.1
- postgresql-8.0-312.jdbc3.jar
- PostgreSQLPlugin from Wonder (recent CVS)
- indexes on all related columns
When I try a simple select via a WODisplayGroup I get response times
of about 1200ms, on a table with about 45.000 records and a result
set of 11 records.
When I use the same select statement on the commandline via psql I
have response times of about 9 to 10ms.
I have also tried a rawRowsForSQL statement that takes about 400ms,
the select in psql takes about 4ms.
How can this happen? What am I doing wrong? A factor of about 100
can't be normal!
cug
System-Config:
- Mac OS X 10.4.2
- Java 1.4.2
- WebObjects 5.3 or 5.2.4
- Powerbook G4
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden