3 ms·
Ask HN: How many columns do you have on your Users column in your db?
We've currently got 26 columns on our users tables. I'm curious how that compares on average.
- DigitalSea 13y agoAs it stands in a classifieds application app I have 9 columns: ID, username, password, email, last_login, role_id, status, auth_code, remember_me Just out of curiosity why do you have 26 columns? I presume you're also storing data like first_name, last_name, address, country, etc? I am too, but I cleverly have a user_meta table that allows dynamic user meta values. Your approach is probably faster because you're not joining any other tables.
- goofygrin 13y agoYour cleverness means it's slow in some instances... Getting a list if users with a diverse criteria set is a gnarly query...