2. PHPRunner General questions
  3. difference in link generation
This topic is locked

difference in link generation

 		8/18/2025 9:57:02 AM
PHPRunner General questions
L
 luchoadmin author

Hello, I have two projects in two companies, and I have a problem I don't know how to solve. In both companies, the tables are the same. One is called production log and the other is heavy_in. One is master and the other is detailed. When I try to upload data, the link is different.

http://localhost/empresa1/pesadas_int_add.php?page=add&masterkey1=869&mastertable=registro_de_producciones

and

http://localhost/emrpesa2/pesadas_int_add.php?mastertable=registro_de_producciones&masterkey1=1226

The problem is that the first link, when I generate the record, takes at least 6 seconds to register it in the database, but the second link is generated in less than 1. Now, if I set up the link format for company 2, the speed also improves. What I don't know is how to get PHPRunner to generate the link for company 1 as it is generated for company 2.

thank you
ChatGPT 8/18/2025

To resolve your issue with PHPRunner and the different link formats leading to varying performance when adding records, you can follow these steps:

  1. Check the Database Connection:
    Make sure that both projects are connected to the same type of database (e.g., MySQL, PostgreSQL) and that the configurations are identical. Sometimes, performance issues can stem from differences in database settings or server configurations.


  2. Examine the Query Execution:
    Use a database management tool (like phpMyAdmin, or any SQL client) to log the queries being executed when you add records. This could provide insight into why one project is slower. Check for any differences in indexes, triggers, or constraints that could be affecting performance.


  3. Optimize the Database:
    If you find that the slower project has additional triggers, constraints, or complex indexes, consider optimizing them. You could also analyze the tables for any potential issues and optimize them via OPTIMIZE TABLE commands if you're using MySQL.


  4. Check PHPRunner Settings:
    In PHPRunner, ensure that both projects have the same settings for adding records. Navigate to the "Add" section in the project settings and compare options such as:

    • Enable AJAX: It can improve performance by not having to reload the entire page.
    • Use Modals: If enabled, it can also help to speed up the interaction.
    • Custom SQL Queries: Check if there are any custom SQL queries or events in the slower project that might be affecting performance.


  5. Link Format Configuration:
    If the link format for company 2 is faster and you want to replicate it for company 1, you can do the following:

    • Go to the "Page settings" for the add page in PHPRunner for company 1.
    • Check the "Add" page URL settings and ensure they match the format from company 2.
    • Look for any custom scripts or configurations that could be affecting how the links are generated.


  6. Debugging:
    Enable debugging in PHPRunner to see if there are any errors or warnings that could indicate why the process is slower in company 1. Sometimes, unexpected behavior can be traced back to misconfigurations or overlooked errors.


  7. Consult PHPRunner Support:
    If you have gone through the above steps and are still facing issues, consider reaching out to PHPRunner support. They may have insights specific to your version of the software or configurations that could help resolve the performance discrepancy.



By following these steps, you should be able to identify the root cause of the performance differences and configure PHPRunner for company 1 to generate links that perform similarly to those in company 2.