RE: [PHP-DB] enum and bad planning
| From: | John W. Holmes | Date: | Tue, 01 Oct 2002 23:24:58 +0000 |
| Subject: | RE: [PHP-DB] enum and bad planning | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22140@lists.php.net to get a copy of this message | ||
> At 03:35 PM 10/1/02 -0400, John W. Holmes wrote:
> >You should BENCHMARK the two solutions and see which is faster. Or
use
> >EXPLAIN to see if there is any difference.
>
> I have no doubt this will be slower. Oh well, he wanted to keep the
table
> definitions.
>
> Don't forget to consider the time required for the programmer to
change
> all
> the programs
> that already have been coded.
I meant the two different queries that still solve the problem with the
columns set to Y or N. Someone gave one query with a bunch of Ifs and I
gave a solution with length and replace, etc. See which one of those is
faster.
---John Holmes...