12,000 entries is absolutely nothing. You can have millions of entries perfectly fine. It's all optimized with proper indexes. Every field, tab, and profile of each user has an entry (if privacy for those usages are enabled). Are you having any problems with CB Privacy or performance to cause you to be concerned about the table size?
Not sure what kind of structure you're proposing. One is cramming all privacy rules into a single row for a user then into a text column. Problem with this is it's incredibly slow, impossible search for a specific privacy rule, can't be indexed, and requires heavier PHP parsing to find a privacy rule. This works great for params usage, but that's about it. One column per rule means dynamically altering the database structure on every privacy store to ensure the column exists and create it if it doesn't. Neither of those solutions are acceptable for performance.
In short the literal design and purpose of a database table is to store massive amounts of rows.
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.
krileon
