[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-09-26 06:31) wrote:

BTW, if the goal is performance, the table WHUPS_LOGS should be
reingeneered,
i.e. column LOG_VALUE_INT of type INT should be added.
Of course, the php code that maintains this table should be fixed also,
by inserting CHARs into LOG_VALUE and INTs into LOG_VALUE_INT.
When the JOINs are necessary, you use comparison for LOG_VALUE_INT and
foreign table's ID.
This achieves the best performance due to foreign primary key scan;
eliminates cross-field-type comparison, and the performance hits introduced
by
any implicit/explicit typecasting, LIKE predicate overhead which introduces
full table scans. And obviously this technique is guaranteed portable.
So if you won't make these architectural changes (however they are
preferred), I'll do the benchmarking you asked for, there's no problem.