Re: PostgreSQL performance through Plugin/JDBC
Re: PostgreSQL performance through Plugin/JDBC
- Subject: Re: PostgreSQL performance through Plugin/JDBC
- From: Arturo Perez <email@hidden>
- Date: Tue, 30 Aug 2005 10:28:58 -0400
Guido Neitzer wrote:
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
Do you mean you literally take the SQL from the WO run log and paste it
into psql? Or are you typing in what you think the SQL was?
Some off-the-cuffs:
Is the casting correct? I know older versions of pgSQL are sensitive to
mismatches between query data type and column datatypes. The plugin is
supposed to address this, and so is pgSQL 8.0.
Perhaps WO is connecting differently then psql? For example, psql might
be using a Unix socket while WO is using an Internet socket? IPV4 vs IPV6?
You may want to try a different JDBC version and see if that varies.
-arturo
_______________________________________________
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