https://legacy.forums.gravityhelp.com/topic/possible-optimizations-in-send_emails Gravity Support Forums Topic: Possible optimizations in send_emails? en-US Mon, 20 Apr 2026 15:23:23 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/possible-optimizations-in-send_emails#post-52613 Thu, 15 Mar 2012 18:25:10 +0000 sboisvert@bryxal.ca 52613@https://legacy.forums.gravityhelp.com/ <p>It seems that the database is being queried for every variable when using '{all_fields}' in an email notification. I didn't think much of it until I saw how much slower that page was than others and getting the time profile graph it seemed that it could definitely be optimized. it seems to take about 80ms per call thru this path:</p> <p>GFCommon::get_submitted_fields<br /> GFormsModel::get_lead_field_value<br /> RGFormsModel::get_field_value_long<br /> wpdb::get_var<br /> W3_Db::query<br /> wpdb::query</p> <p>And it is being done 17 times during the course of sending 2 emails of a form that has 6 fields.<br /> It might be worth looking into caching the results of the query the first time around in a global variable and re-using that? (or some other way to optimize this, I'm not 100% sure of what exactly the code does, just that it ads 1s that I believe might be able to be shaved off)</p> <p>Hope this can be of use!</p> <p>-Steph </p>