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?

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.

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)".

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: