{"id":696,"date":"2012-03-18T22:28:25","date_gmt":"2012-03-19T02:28:25","guid":{"rendered":"http:\/\/cfdbplugin.com\/?p=696"},"modified":"2014-10-22T06:59:29","modified_gmt":"2014-10-22T10:59:29","slug":"making-short-code-perform-faster","status":"publish","type":"post","link":"https:\/\/cfdbplugin.com\/?p=696","title":{"rendered":"Making Short Code Perform Faster"},"content":{"rendered":"<p>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=&#8221;true&#8221;.<\/p>\n<p>Example: change <code>[cfdb-table form=\"form1\"]<\/code> with <br \/> <code>[cfdb-table form=\"form1\" <span style=\"color: #ff0000;\">unbuffered=\"true\"<\/span>]<\/code><\/p>\n<p>However: this cannot be used if you are nesting a short code inside another short code that is also doing a query. It doesn&#8217;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.<\/p>\n<p>Technical: This option makes use of the PHP <a href=\"http:\/\/php.net\/manual\/en\/function.mysql-unbuffered-query.php\" target=\"_blank\">mysql_unbuffered_query<\/a> function instead of <a href=\"http:\/\/php.net\/manual\/en\/function.mysql-query.php\" target=\"_blank\">mysql_query<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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=&#8221;true&#8221;. Example: change However: this cannot [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,13],"tags":[],"class_list":["post-696","post","type-post","status-publish","format-standard","hentry","category-shortcode","category-tips"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1mptf-be","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/posts\/696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=696"}],"version-history":[{"count":6,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/posts\/696\/revisions"}],"predecessor-version":[{"id":704,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/posts\/696\/revisions\/704"}],"wp:attachment":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}