Query Speed
Permalink Browser Info Environment
Hi,
I'm a very happy user of a 5.6 version of Data Display. It works wonderfully for me to provide a client a fairly complex set of forms as a unified database. Only trouble is the screens can take a bit too long to render. The screens are all passing a query string through the URL of the page. Sometimes the page takes 20 seconds to render. There are 9 forms with a total of about 1,500 records shared between those forms. The website generally is fast so I don;t think its a resource problem. Could I possible add a mysql index to some columns to increase query speed?
I'm a very happy user of a 5.6 version of Data Display. It works wonderfully for me to provide a client a fairly complex set of forms as a unified database. Only trouble is the screens can take a bit too long to render. The screens are all passing a query string through the URL of the page. Sometimes the page takes 20 seconds to render. There are 9 forms with a total of about 1,500 records shared between those forms. The website generally is fast so I don;t think its a resource problem. Could I possible add a mysql index to some columns to increase query speed?
Type: | Discussion |
---|---|
Status: | In Progress |
Opps sorry, I note in your changelog.txt inside package you have a roadmap that included Import.
Road Map Finish rules Finish attributes Import/Export Data eCommerce Stripe Integration Authorize.Net Integration PayPal Integration MailChimp Integration Repeatable Field Groups Pass handle via URL (for Formify View) CAPTCHA Ability to edit file select field
Import/export is up next on the Road Map!
Formify should be significantly faster than Advanced Forms. It uses an entirely different format for data storage that allows it to pull records much more quickly. Keep an eye out for version 1.2, which will be coming out soon.
Formify should be significantly faster than Advanced Forms. It uses an entirely different format for data storage that allows it to pull records much more quickly. Keep an eye out for version 1.2, which will be coming out soon.
Hi James,
Appreciate all your work. When do you think you will get to version 1.2 with Data Import :-)
Appreciate all your work. When do you think you will get to version 1.2 with Data Import :-)
Any date anticipation for version 1.2 with data import?
Just posted version 1.2, which includes the ability to import records from CSV.
Hi,
Thanks very much for making the update the package to include import and taking the time to answer this post. I've commenced migration of this particular deployment of Data Display into Formify but I've now discovered the existing Data Display deployment makes heavy use of passing queries in URL to filter list views. Is this what you're deliverying in the roadmap when you say "Pass handle via URL (for Formify View)".
If it is when will you be doing it :-)
Thanks very much for making the update the package to include import and taking the time to answer this post. I've commenced migration of this particular deployment of Data Display into Formify but I've now discovered the existing Data Display deployment makes heavy use of passing queries in URL to filter list views. Is this what you're deliverying in the roadmap when you say "Pass handle via URL (for Formify View)".
If it is when will you be doing it :-)
Well...I've got a number of other issues I'm trying to knock out ahead of that...but still, very soon. I've bumped the e-commerce and attribute stuff down below this item in the roadmap now, since I don't have any customers actively in need of those. So as of now...working on:
1. Export functionality.
2. Fixing some bugs with field rules.
3. MailChimp Integration
4. Passing handle via URL
Each of the first three are pretty straightforward. Hoping to know them out in the next few days, then the URL parameter stuff will be up next.
1. Export functionality.
2. Fixing some bugs with field rules.
3. MailChimp Integration
4. Passing handle via URL
Each of the first three are pretty straightforward. Hoping to know them out in the next few days, then the URL parameter stuff will be up next.
There is a Formify import screen but it is blank. Just checking if "Import" is a future feature?