[drupal-devel] Re: MySQL ENUM vs. TINYINT (possible, > performance boost?)

[piotrwww at krukowiecki.net]

On Sun, Oct 16, 2005 at 08:42:58PM -0400, David Norman wrote:
> I would bet enum is faster (and no I don't have proof). The analyze
> function in phpMyAdmin even recommends enums in places it recognizes
> boolean values. Just because mysql would use enum, wouldn't mean pgsql
> would have to use bool - it could stay as an integer.

Right, postgres could stay as it is, as long as you don't expect in your
code special ENUM behaviour.


-- 
Piotrek
irc: #debian.pl
Mors Drosophilis melanogastribus!