INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Quixote on January 09, 2006, 11:50:52 am

Title: Field Type choices- Best Practice?
Post by: Quixote on January 09, 2006, 11:50:52 am

When creating a custom user fields how much different would using an Interger type be verses using a String type?  How significant are performance differences between the two?  I'm creating many Yes/No-esque fields.

For example:

Field:  IsInstrumental, IsProfane

What is the "best practice" design for this field?  As a String with "Yes,No" List options? As an Integer with "1,2" List options?  How much does performance take a hit when expanding list options to 3+ items?

Title: Re: Field Type choices- Best Practice?
Post by: hit_ny on January 09, 2006, 12:34:43 pm

I doubt there is that much of a difference beteen String or Integer in terms of performance. They are stored in the database as types. You are not calling these types 100s of times a second.

It's more a choice of which you prefer.