https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable Gravity Support Forums Topic: optimizing GFCommon::replace_variable en-US Mon, 20 Apr 2026 15:19:52 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73355 Thu, 30 Aug 2012 18:44:16 +0000 Chris Hajer 73355@https://legacy.forums.gravityhelp.com/ <p>From the lead developer Alex Cancado:</p> <blockquote><p> I have added that index to the lead detail table. If this comes up again I can take a deeper look and see if there is something else that can be done. </p></blockquote> <p>Thanks for the suggestion. </p> https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73193 Wed, 29 Aug 2012 20:53:19 +0000 Chris Hajer 73193@https://legacy.forums.gravityhelp.com/ <p>That's a crazy amount of entries :-) </p> https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73170 Wed, 29 Aug 2012 17:58:55 +0000 sboisvert@bryxal.ca 73170@https://legacy.forums.gravityhelp.com/ <p>I believe its only a problem once you start getting in the 100 000+ form entries. </p> https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73169 Wed, 29 Aug 2012 17:57:52 +0000 sboisvert@bryxal.ca 73169@https://legacy.forums.gravityhelp.com/ <p>That was from New Relic transaction traces. </p> https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73130 Wed, 29 Aug 2012 16:09:55 +0000 Chris Hajer 73130@https://legacy.forums.gravityhelp.com/ <p>What tool did you use to benchmark that?</p> <p>I will bring this to the attention of the developers. Thanks for posting this. </p> https://legacy.forums.gravityhelp.com/topic/optimizing-gfcommonreplace_variable#post-73114 Wed, 29 Aug 2012 15:29:28 +0000 sboisvert@bryxal.ca 73114@https://legacy.forums.gravityhelp.com/ <p>If you have a look here:<br /> <a href="https://trello-attachments.s3.amazonaws.com/4f0680090bd2eb29720c5203/4f19acb1a63c9d76680115fe/15d8c3dfa13479c10918b94c80952280/upload_2012-08-29_at_3.23.54_pm.png" rel="nofollow">https://trello-attachments.s3.amazonaws.com/4f0680090bd2eb29720c5203/4f19acb1a63c9d76680115fe/15d8c3dfa13479c10918b94c80952280/upload_2012-08-29_at_3.23.54_pm.png</a></p> <p>You'll notice that in our setup the funtion GFCommon::replace_variable() is taking a lot of time. Over 2s total in a request. I'm sure there are many ways that you could optimize this and you guys would probably be much better at this than I am, but one simple thing we've done to help this is create an index on Lead_id and field_number. It seems to have helped us. Perhaps it would help others as well. </p>