db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Petr Bodnar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TORQUE-36) Select performance problem with Sybase
Date Tue, 12 Jan 2016 16:12:40 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-36?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15094164#comment-15094164
] 

Petr Bodnar commented on TORQUE-36:
-----------------------------------

Sorry for "re-opening" this topic, but what was the actual problem in here? Was it the redundant
metadata query done by the Village library? It's not clear from the description and comments.
And is this really specific just for the Sybase database? I would guess this problem will
occur even when running against other databases...

> Select performance problem with Sybase
> --------------------------------------
>
>                 Key: TORQUE-36
>                 URL: https://issues.apache.org/jira/browse/TORQUE-36
>             Project: Torque
>          Issue Type: Bug
>          Components: Runtime, Village
>    Affects Versions: 3.2
>         Environment: Java 1.4.2 on solaris 10 against Sybase 12.5.2
>            Reporter: Joe Carter
>            Assignee: Thomas Vandahl
>             Fix For: 3.3.1
>
>
> Selects via Torque perform 2-3 times slower than when doing the identical statement via
JDBC.
> I took the SQL produced by Torque using p6spy to capture it.
> I manually implemented the same SQL as a raw query and a prepared statement
> obtaining a SQL connection from Torque.getConnection() to eliminate any differences in
the pooling etc.
> I then ran performance tests against the 3 types.
> The ratio in performance (big is slower) was 10-4-3 for standard Torque, raw and then
prepared statements.
> The performance hit was definately against the database as we're seeing similar performance
improvements
> on production systems with the database CPU usage dropping dramatically with some gains
on the calling tomcat server.
> The suspicion is that metadata is being retrieved on every select but p6spy unfortunately
does not 
> support the reporting of this so this cannot be confirmed.
> Note that the tests were performed without p6spy in the loop.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message