i'm going to start my first project on Drupal so i made some search and some scouting regarding users management with drupal but i still have some doubt about it.
I've found that all additional account fields that i can request in registration form are stored in separate database tables fields_data_field_.

Is that the actual best practice for an extensive user management website? Anyone can suggest me a better option?
Which is the smartest way to import existing users list (xls) into new drupal's database?

Thanks in advance guys
Phil

Comments

Jaypan’s picture

I've found that all additional account fields that i can request in registration form are stored in separate database tables fields_data_field_.

The Entity Cache module is used to deal with this. Once the entity has been generated a single time (by joining all those tables), the entity is then cached, and the fact that the data is split across multiple tables becomes irrelevant.

WorldFallz’s picture

To add to what jay said, if you don't want the additional info added directory to the user entity there's the profile2 module which is on track to be added to core eventually.

Noe_’s picture

If you notice the site slowing down you could also try to use Redis, or MemCache.

Or any other of the caching modules, or performance modules.

--
Noë Snaterse
WiredPea