[support] Database : why the type fields are varchars

melantias toomaate melantias at gmail.com
Tue Apr 3 12:17:50 UTC 2007


Hi,

We are going to build a web site using Drupal. I am new to Drupal CMS.
 While going through the drupal tables, i found that the 'type' field
in 'node_type' table is varchar. I am eager to know - why the type
fields are varchars instead of integers.
I would like to know this because varchars are slow in table joins and
searching. I believe there is a
specific reason in making the type fields - varchars.  Please let me know.

Thank you in advance,

Regards,
T.Melantias,
Programmer Analyst,
Olive Technology
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070403/585bfc44/attachment.htm 


More information about the support mailing list