Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Quixote]

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?

[hit_ny]

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.