> I try to guess in my head what is the best length for this field to optimize for performance, but sounds like using unlimited length (textfield) field doesn't make any difference.

That used to be a good idea. I guess it's fallen the way of defragging, or "parking" your hard drive.