You are viewing a plain text version of this content. The canonical link for it is here.

Posted to slide-user@jakarta.apache.org by Tim Anderson <ti...@intalio.com> on 2002/03/03 01:21:44 UTC

JDBC performance

Hi people,
    I'm trying to use Slide with Oracle and Sybase, and have found the
slidestore.reference.JDBCDescriptorsStore
class to be a major bottleneck in terms of performance.
The schema it creates is not normalized, and most of the tables don't have
any indexes. For Sybase,
indexing columns gives approximately 100% improvement, but even on a small
data set, its
too slow to be usable.

Has anyone redeveloped the JDBC layer to improve its performance, and would
care to contribute it
back to the project?  If not, I'll have a stab at it....

Thanks

Tim