I've found a thread discussing the use of "text" vs. "varchar"; what I'd like to know if there's any performance difference between using "varchar(n)" vs. "varchar", ie, should I constrain a "name" column to an arbitrary length to improve performance, or will it actually degrade performance because of the extra cycles used for checking the length?
