jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martijn Hendriks" <marti...@gx.nl>
Subject Oracle does not use index on NODE_ID column
Date Fri, 31 Aug 2007 09:44:46 GMT
Hi all,

We've noticed that some queries with the oracle bundle persistence
manager are very slow (an order of magnitude slower than with MSSQL for
instance). This seems to be due to an implicit conversion from a raw
value to a varchar2 which disables the index (see
http://orafaq.com/maillist/oracle-l/2007/02/14/1050.htm).

Would it be possible to use the suggested HEXTORAW function, or does
that have unwanted side effects?

I.e., use "select BUNDLE_DATA from " + schemaObjectPrefix + "BUNDLE
where NODE_ID = HEXTORAW(?)";

Best regards,

Martijn


--

Martijn Hendriks
<GX> creative online development B.V.
 
t: 024 - 3888 261
f: 024 - 3888 621
e: martijnh@gx.nl
 
Wijchenseweg 111
6538 SW Nijmegen
http://www.gx.nl/ 

Mime
View raw message