Query Speed

Permalink Browser Info Environment

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
View Replies:
unionsystems replied on at Permalink Reply
I've just installed Formify onto 5.7 to test if its faster but I have discovered it does not have an Import function so I cannot import my 1,500 records.

There is a Formify import screen but it is blank. Just checking if "Import" is a future feature?
unionsystems replied on at Permalink Reply
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
Stripe Integration
Authorize.Net Integration
PayPal Integration
MailChimp Integration
Repeatable Field Groups
Pass handle via URL (for Formify View)
Ability to edit file select field
jgarcia replied on at Permalink Reply
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.
unionsystems replied on at Permalink Reply
Hi James,

Appreciate all your work. When do you think you will get to version 1.2 with Data Import :-)
unionsystems replied on at Permalink Reply
Any date anticipation for version 1.2 with data import?
jgarcia replied on at Permalink Reply
Just posted version 1.2, which includes the ability to import records from CSV.
unionsystems replied on at Permalink Reply

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 :-)
jgarcia replied on at Permalink Reply
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.

concrete5 Environment Information

# concrete5 Version

# concrete5 Packages
Advanced Forms (1.13.1), All In: The Advanced User Import Add-on (2.0), Awesome Table (1.0.6), Bootstrap (, Bootstrap Buttons (, Breadcrumbs (1.0), Data Display (, Document Library (1.6.4), Easy Accordion (1.1.2), Extended Google Map (3.3.5), Force SSL (2.6), Formidable (2.1.3), Formwork5 Help (1.0.0), Google Map (Premium) (2.1), Honeypot (1.0), Login (1.1.1), Login Redirect (1.4), MindNet Optimize MySQL database (1.11), Pro Forms (7.6.2), Redirect (1.1), Show Page Title (1.0), Social Feed (1.7), Social Login (1.2), SQL Buddy (1.0), Traffic & Statistics (3.08), Vegas (0.0.6).

# concrete5 Overrides
blocks/list_files_from_set, blocks/page_list, blocks/swp_breadcrumbs, elements/profile, languages/ja_JP, languages/tr_TR, languages/es_ES, languages/el_GR, languages/fi_FI, languages/zh_TW, languages/sk_SK, languages/sl_SI, languages/es_AR, languages/nb_NO, languages/sv_SE, languages/fa_IR, languages/ro_RO, languages/ru_RU, languages/es_MX, languages/fr_FR, languages/cs_CZ, languages/es_PE, languages/nl_NL, languages/pt_PT, languages/da_DK, languages/de_DE, languages/vi_VN, languages/ar, languages/it_IT, single_pages/profile, themes/boostrap

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - Off
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every minutes.

# Server Software
Apache/2.2.31 (Amazon)

# Server API

# PHP Version

# PHP Extensions
apache2handler, apc, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, json, libxml, mcrypt, mhash, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib.

# PHP Settings
max_execution_time - 1024
apc.max_file_size - 2M
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 120
max_input_vars - 1000
memory_limit - 128M
post_max_size - 80M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 100M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.99 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.