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

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