[Tickets #606] Typecasting required in whups/lib/Driver/sql.php on Oracle

[bugs at bugs.horde.org]

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.