Large number of fields

Hi,

I have a question about the number of fields and the operation of the cb_conditionals plugin. I have built an information database where each user has around 40 fields in their profile, however I would like to expand this to allow different sets of questions based on a dropdown. My understanding is that the entire set of fields will be created when the user is? So if I have 10 options in the dropdown with 40 different questions in each, the total amount is going to add up very quickly (10x40 means 400 fields per user). Is this just going to be too much information for the database to handle when the account is created and also in general use?

If you've 10 options and 40 fields for each option then yes you'll have 400 fields. You should consider very carefully your field structure and what's important. Reuse fields whenever possible. While CB can handle those 400 fields it does add 400 database columns to _comprofiler and the more you add the slower the _comprofiler queries will get. So not only is it vital to be easy on your users to fill out it's also vital to performance. Roughly the maximum number of fields you can have for InnoDB is 1,000.