db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Carter" <joe.car...@excite.com>
Subject Re: Performance issues when using postgresql-8.1-404.jdbc3.jar
Date Wed, 14 Jun 2006 09:02:32 GMT
Hi,

Interestingly I suspect we're seeing similar problems with Sybase.
When I manually implement a select instead of using Torque's save()
I seem to get about twice the performance.

Can you tell me precisely what you changed?
I'd like to try it with our system.

Thanks

Joe

On 12/06/06, Tassos Bassoukos <abassouk@gmail.com> wrote:
>
> Greetings,
> I've encountered an interesting performance disparity when using
> torque, specifically requests from torque took 40+ms to complete
> (based on the timing in BasePeer), while the database reported
> completion in 1-2ms.
>
> After some digging, it looks like a village-postgresql mismatch, in
> the sense that village caches the metadata for all columns in a query,
> but postgresql will emit an extra (internal) query to fetch two
> metadata options: for the nullAllowed and autoIncrement properties.
>
> That is, for a select with 6 fields, a total of 13 round-trips to the
> server are made.
>
> Now comes the interesting bit: These attributes aren't used anywhere.
> I've removed these attributes (and their accessors), and everything
> compiled and plays fine....
>
> Tassos Bassoukos
> P.S.: I'm not subscribed to the list, so you may want to CC me for a
> fast response.
> P.P.S.: This is all on stock torque 3.2
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message