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

piotrwww at krukowiecki.net piotrwww at krukowiecki.net
Mon Oct 17 09:11:03 UTC 2005

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.

irc: #debian.pl
Mors Drosophilis melanogastribus!

More information about the drupal-devel mailing list