Performance, 30k rows
Permalink Browser Info Environment
Hello, using the latest concrete5(.6) and add-on, my sixeightformsAnswers table has about 30k records, and sixeightformsAnswerSets has 2780 rows. Making any edits using either the front end, or the dashboard page takes several minutes (3-5) to apply - the spinner says Processing...
Loading concrete5 pages and other database access are fine, I have about 15 forms and they are all this speed from the dashboard. The most records is 900 in any one form.
Are there any indexes I can add or anything of that nature? Straight SELECT queries from a query tool are fast - it seems to be limited to using the Advanced Forms interface. Thanks in advance.
Loading concrete5 pages and other database access are fine, I have about 15 forms and they are all this speed from the dashboard. The most records is 900 in any one form.
Are there any indexes I can add or anything of that nature? Straight SELECT queries from a query tool are fast - it seems to be limited to using the Advanced Forms interface. Thanks in advance.
Type: | Discussion |
---|---|
Status: | In Progress |
I would like to amend my statement earlier that all forms are slow - I have a few that actually perform really well. Please let me know how I might narrow down the cause of 1 form performing poorly. Thank you!
I'm actually having a similar issue - except my sixeightformsAnswers table has ~750,000 rows.
To be honest with you, I'm planning to do a full rewrite of Advanced Forms for Concrete 5.7, so this fix will likely be worked into that version. To try to address this for the current version would require some pretty significant changes to the core of how the add-on functions.
To be honest with you, I'm planning to do a full rewrite of Advanced Forms for Concrete 5.7, so this fix will likely be worked into that version. To try to address this for the current version would require some pretty significant changes to the core of how the add-on functions.