[Tickets #606] Typecasting required in whups/lib/Driver/sql.php on
Oracle
bugs at bugs.horde.org
bugs at bugs.horde.org
Tue Oct 12 10:22:54 PDT 2004
DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/?id=606
-----------------------------------------------------------------------
Ticket | 606
Updated By | rvs at angara.ru
Summary | Typecasting required in whups/lib/Driver/sql.php on Oracle
Queue | Whups
State | Feedback
Priority | 2. Medium
Type | Bug
Owners | Chuck Hagenbuch
-----------------------------------------------------------------------
rvs at angara.ru (2004-10-12 10:22) wrote:
Well I've conducted some benchmarking tests as you asked me for.
In general, the efficiency of both LIKE and CAST() is mostly
database-specific,
and results vary from one RDBMS to another.
Regarding ORACLE, when no special measures taken, both methods have
approximately the same performance because both of them cause full scan of
table WHUPS_LOGS, the most expensive seek operation, which overweights the
computational costs of LIKE and CAST() evaluation.
When the LOG_VALUE field is made well-indexed (using functional index), the
CAST() method appears to be a little bit faster.
But this is a minor difference, and requies non-portable DB optimization,
so both methods are bad enough for performance. The reengineering of table
WHUPS_LOGS is unconditionally preferred... Please see my previous comment on
this.
More information about the bugs
mailing list