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.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.