You have exceeded the table column limit!

Hi @brandonwebfast ,

Thank you for reaching out to us.

1. Basically, We kept the limit of 25 columns and 10k rows for performance reasons. But now we might be able to extend it.

2. Could you please share approximately how many columns and rows you might be using?

3. Also may I know if you are using our triggers and actions feature? If so which ones?

Looking forward to hearing back from you.

Kind Regards.

Thank you so much for replying Stephen!

1. That is 100% understandable but in my rare case I really need a lot more than 25 columns :D. It exceeds the limit as I make use of CF7’s extention multi step. I also have a lot of fields that I need to enter in each step. I am personally fine with some performance issues, I can only get it to work with your brilliant plugin!

2. I need 150+ columns so to be safe I would round up to 160.

3. Trigger: – Contact Form 7
– On Form Submit
– COC Form

Actions: – Tablesome
– Add Row

Kind Regards
Brandon

Hi Brandon,

Thanks much for getting back to us.

Our team is currently investigating on this. I will get back to you soon.

Kind Regards.

Hi @pauple123

That’s great news!

Can’t wait to hear from you.

Thank you very much

Kind Regards

Hi @pauple123

Is there any updates regarding this topic?

Kind regards.

Hello @brandonwebfast ,

Thanks for waiting. Here’s the report on loading 150 columns

Loading Max Columns Report
Columns -> 150
Rows -> 500
Table Loading Time – 69.73s

https://postimg.cc/gLYV2F9t

Seems impractical for your use case. The only other (tedious) option as of now, is to store data in multiple tables.

We hope to improve performance in the future, but currently our backlog is full with other items. Regret not being able to offer a better solution for you at the present moment.

• This reply was modified 2 years, 7 months ago by Essekia.
• This reply was modified 2 years, 7 months ago by Essekia.

@essekia

Will this be the same effect if I only insert 1 row at a time?

Because it will be 150+ columns but only 1 row for each column.

Will this still be the same Table Load Time?

Kind Regards

@brandonwebfast,

If its 150 columns and 150 rows, it would be a little faster. (around 20-30seconds). This seems like a rare use case that we would have to give it in the Pro version.

Can you tell me more about your use case?