https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database Gravity Support Forums Topic: Consistent overhead added to database en-US Mon, 20 Apr 2026 01:00:13 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database#post-51459 Tue, 06 Mar 2012 13:25:47 +0000 JimBurke 51459@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>I'm interested in this too.</p> <p>In my app, I have no need for the entries or posts created by Gravity Forms. The reason is that I handle all the population &amp; saving directly into a separate database, using hooks &amp; filters.<br /> Therefore, GF is creating posts &amp; entries for which I have no need.</p> <p>Q1. Can I delete everything in the rg_leads... tables ?<br /> Q2. Can I switch it off altogether ?<br /> Q3. Can I prevent GF from creating posts ?</p> <p>Many thanks,<br /> Jim Burke </p> https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database#post-46056 Tue, 10 Jan 2012 20:52:01 +0000 Chris Hajer 46056@https://legacy.forums.gravityhelp.com/ <p>I don't think it will. MySQL is pretty smart. If you notice a performance issue, we're happy to take a look at it with you and see if we can make improvements. </p> https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database#post-46054 Tue, 10 Jan 2012 20:44:24 +0000 jacorre 46054@https://legacy.forums.gravityhelp.com/ <p>I was researching something else but started to notice each time I submitted something with the form the overhead was increasing each time. So I was wondering if this would affect performance? </p> https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database#post-46045 Tue, 10 Jan 2012 19:35:08 +0000 Chris Hajer 46045@https://legacy.forums.gravityhelp.com/ <p>What caused you to look at this? Were you having performance issues? </p> https://legacy.forums.gravityhelp.com/topic/consistent-overhead-added-to-database#post-45756 Sat, 07 Jan 2012 01:13:09 +0000 jacorre 45756@https://legacy.forums.gravityhelp.com/ <p>I'm noticing that there is overhead added to the lead and lead_detail tables upon each form submission. I'm only using one form right now. </p> <p>Because I'm filing to a custom post type, I don't want the form entries to be saved. So I am using the following function to delete them:</p> <pre><code>function remove_form_entry($entry, $form){ global $wpdb; $lead_id = $entry[&#39;id&#39;]; $lead_table = RGFormsModel::get_lead_table_name(); $lead_notes_table = RGFormsModel::get_lead_notes_table_name(); $lead_detail_table = RGFormsModel::get_lead_details_table_name(); $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name(); //Delete from detail long $sql = $wpdb-&gt;prepare(&quot; DELETE FROM $lead_detail_long_table WHERE lead_detail_id IN( SELECT id FROM $lead_detail_table WHERE lead_id=%d )&quot;, $lead_id); $wpdb-&gt;query($sql); //Delete from lead details $sql = $wpdb-&gt;prepare(&quot;DELETE FROM $lead_detail_table WHERE lead_id=%d&quot;, $lead_id); $wpdb-&gt;query($sql); //Delete from lead notes $sql = $wpdb-&gt;prepare(&quot;DELETE FROM $lead_notes_table WHERE lead_id=%d&quot;, $lead_id); $wpdb-&gt;query($sql); //Delete from lead $sql = $wpdb-&gt;prepare(&quot;DELETE FROM $lead_table WHERE id=%d&quot;, $lead_id); $wpdb-&gt;query($sql); } add_action(&#39;gform_after_submission_1&#39;, &#39;remove_form_entry&#39;, 10, 2);</code></pre> <p>Does that have anything to do with it? How does this affect performance? I know optimization of the database tables is something that should be done as part of maintenance, but will I need to monitor this all the time especially if I notice lag time on the site? </p>