MachForm Community Forums » MachForm 4

1. enuffsaid
   Member

   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.

   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?

   Thanks in advance.

   Posted 9 years ago #

2. Saghalie
   Pro Member

   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.

   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.

   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.

   Regards,

   Saghalie
   http://www.kcmhosting.com

   Posted 9 years ago #

3. enuffsaid
   Member

   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.

   Posted 9 years ago #

4. enuffsaid
   Member

   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.

   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.

   Regards.

   Posted 9 years ago #

5. enuffsaid
   Member

   This problem has been resolved with the suggestion from Yuniar Setiawan to run:

   ALTER TABLE ap_form_payments ADD INDEX (form_id,record_id);

   Thank you.

   Posted 9 years ago #

RSS feed for this topic

Reply

You must log in to post.