Skip to Content Skip to Menu

Code

  • bmeeker
  • bmeeker
  • OFFLINE
  • Posts: 65
  • Thanks: 8
  • Karma: 1
1 year 3 months ago #334814 by bmeeker
Replied by bmeeker on topic Code
You mention:
"We'll be completely redesigning field storage in CB 3.x though to eliminate any field limitations."

When is the anticipated release of CB 3.x?

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
1 year 3 months ago #334817 by krileon
Replied by krileon on topic Code
No idea. We'll be starting CB 3.x development this year and slowly rolling it out. It will primarily start as just an independent application layer as we plan to expand CB to WordPress and eventually standalone. Field storage rewrite probably won't happen until a little ways into CB 3.x where we'll be moving field storage to a separate table and 1 row in that table per user field, which will eliminate storage limits.


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.

Please Log in or Create an account to join the conversation.

  • bmeeker
  • bmeeker
  • OFFLINE
  • Posts: 65
  • Thanks: 8
  • Karma: 1
1 year 3 months ago #334858 by bmeeker
Replied by bmeeker on topic Code
Thanks Kyle!

I am going to try to reduce the database row size.
I need some advice - I'm not that good at knowing how to figure the size of a field type.

From reviewing the database, it looks like Radio Buttons are stored as text and single Checkboxes are stored as tinyint.
I can change over 30 Radio Buttons to single Checkboxes.

Do you think it will make a difference in the row size?
Is that is a good place to start before eliminating fields I'd like to keep? 
Next fields I would eliminate would be Editor Text Areas - does that also make sense?

Thanks for your help.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
1 year 3 months ago #334861 by krileon
Replied by krileon on topic Code
Our field types are basically already using as small of a column type as they can. Ideally you should review your current setup and see how it can be improved and reduced.

I can change over 30 Radio Buttons to single Checkboxes.

Do you think it will make a difference in the row size?

That won't likely make a meaningful impact. Your issue is you've just too many fields for your MySQL configuration.

Is that is a good place to start before eliminating fields I'd like to keep?

The best solution to keep everything you have is to simply change your database configuration. This should be as simple as adjusting innodb_page_size in your MySQL config file. Sometimes this can be done from phpmyadmin if the config file is writeable. The below documentation explains this further.

dev.mysql.com/doc/refman/8.0/en/column-count-limit.html


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.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum