Making Short Code Perform Faster
March 18th, 2012
1 comment
Forms that have many thousands of entries can be slow to return query results or may cause you PHP page to run out of memory. A quick addition to your short code can make the query run by the short code faster and require less memory. This addition is unbuffered=”true”.
Example: change [cfdb-table form="form1"]
with
[cfdb-table form="form1" unbuffered="true"]
However: this cannot be used if you are nesting a short code inside another short code that is also doing a query. It doesn’t work if two queries are running at the same time. An example might be nesting a cfdb short code inside a [cfdb-html] short code.
Technical: This option makes use of the PHP mysql_unbuffered_query function instead of mysql_query.