https://www.machform.com/forums/ MachForm Community Forums Topic: SQL Server Timeout Issues en Mon, 04 May 2026 01:35:17 +0000 https://www.machform.com/forums/topic/sql-server-timeout-issues#post-22449 Fri, 02 Jan 2015 16:17:33 +0000 enuffsaid 22449@https://www.machform.com/forums/ <p>This problem has been resolved with the suggestion from Yuniar Setiawan to run:</p> <p>ALTER TABLE <code>ap_form_payments</code> ADD INDEX (<code>form_id</code>,<code>record_id</code>);</p> <p>Thank you. </p> https://www.machform.com/forums/topic/sql-server-timeout-issues#post-22446 Thu, 01 Jan 2015 08:15:59 +0000 enuffsaid 22446@https://www.machform.com/forums/ <p>Thank you Saghalie, but the Settings on version 4.2 appears to apply only to the amount of "Forms" displayed. The "manage_entries.php" limits the amount of "entries" to 15, but there are no settings for "Paging" or limiting the SQL query return.</p> <p>I can increase the max_execution_time, but I think it's best to restrict the number of records returned initially - but I am new at this.</p> <p>Regards. </p> https://www.machform.com/forums/topic/sql-server-timeout-issues#post-22445 Thu, 01 Jan 2015 08:11:07 +0000 enuffsaid 22445@https://www.machform.com/forums/ <p>PHP MySQL Paging is what I need. Can someone please tell me how I could implement this to the "manage_entries.php" file? Seems like this would (or should) be something native to MachForm. Thanks. </p> https://www.machform.com/forums/topic/sql-server-timeout-issues#post-22443 Thu, 01 Jan 2015 08:04:35 +0000 Saghalie 22443@https://www.machform.com/forums/ <p>The timing issue I believe; is a PHP issue. Check your php.ini (look for max_execution_time) and increase the value until it works.</p> <p>If you want to have a portion of your records displayed, you can set this in your MachForm settings. But this will set all your forms to display however many records you want to display.</p> <p>I don't think that there is anything available to do what you want to have done, but you can put in a customer service request and see if they can help you.</p> <p>Regards,</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/sql-server-timeout-issues#post-22442 Thu, 01 Jan 2015 05:29:06 +0000 enuffsaid 22442@https://www.machform.com/forums/ <p>I have about 7K entries for an event and of course 7K payment records. When I load the MachForm Form Manager and click on Entries, I often get a SQL Server timeout issue. When I reduce the records to say 2000 or less, there does not seem to be an issue. I've noticed that as the amount of records increase in each table, the query takes longer until there is a timeout error while using MachForms. I don't have this issue when querying phpMyAdmin directly from the SQL backend.</p> <p>Question: How can I have the Form Manager return only a portion of the records initially when I click on the Entries tab, then produce the remaining records when required?</p> <p>Thanks in advance. </p>