https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements Gravity Support Forums Topic: MySQL Performance Issue - SELECT count(0) statements en-US Sat, 04 Apr 2026 15:01:45 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements#post-25416 Thu, 12 May 2011 14:02:53 +0000 bkmacdaddy_asg 25416@https://legacy.forums.gravityhelp.com/ <p>Carl,</p> <p>Our forms did have Post Titles but was not required. I have since selected the 'Required' field in hopes that this prevents blank Post Titles. </p> https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements#post-25415 Thu, 12 May 2011 13:59:21 +0000 Carl Hancock 25415@https://legacy.forums.gravityhelp.com/ <p>To follow up on what Alex said, you most likely have a lot of "Untitled" posts because your form is creating posts and never using a Title so you probably have an "Untitled" Post for every form entry... which could be a lot.</p> <p>Why is your form configured to create a Post but without using the Post Title field? Doesn't make much sense to use a form to create a post with no Title. You may be using a Post Body field by accident. If you use Post Fields from the Post Field group of fields in the Form Editor, these should only be used if you want your form to create a Post. But Posts should have a Title so you need to use the Post Title field, your form does not have one otherwise this query wouldn't be executing. </p> https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements#post-25408 Thu, 12 May 2011 12:07:55 +0000 Alex Cancado 25408@https://legacy.forums.gravityhelp.com/ <p>That MySql command is executed when you have a form that has a post field, but not a post title field. It does that to come up with an unique post title. If you have lots of posts with name Untitled_1, Untitled_2, Untitled_3, etc... It is possible that every time your form is submitted, it will execute that sql statement many times until it finds an unique post title to use.<br /> My suggestion is to simply add a post title to your form. You can pre-populate it with variables from the form and mark it as admin only so that it doesn't get displayed in the front end form.</p> <p>I hope this helps. </p> https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements#post-25406 Thu, 12 May 2011 11:48:21 +0000 bkmacdaddy_asg 25406@https://legacy.forums.gravityhelp.com/ <p>We are still looking for urgent assistance with this matter. Our entire server is being choked by these count(0) statements. </p> https://legacy.forums.gravityhelp.com/topic/mysql-performance-issue-select-count0-statements#post-25360 Wed, 11 May 2011 19:10:26 +0000 solvdsystems 25360@https://legacy.forums.gravityhelp.com/ <p>I have a site using the Gravity Forms plugin. therepealpledge.com </p> <p>I am noticing a significant mysql performance issue. I have done everything I can to tweak the MySQL database settings to gain performance. </p> <p>I am constantly seeing several SQL statements similiar to this:</p> <p>SELECT count(0) FROM wp_posts WHERE post_title='Untitled_2597'</p> <p>There are often 10 different types of these select statements and then run continuously. Can someone shed light as to if this is normal and if not or if there is a way I can curb these count(0) statements I would really appreciate it. It's killing my site.</p> <p>Regards,<br /> John </p>