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

* Your Email Address
* Spam protection	Enter the letters below: __. __ .__..__ .___. (__ / `[__][__) \| .__)\__.\| \|[__) \|
Comment	> 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. > >
Attachment
Watch this ticket