HJB 12/8/2023 | |
https://xlinesoft.com/phprunner/docs/how_to_work_with_tab_2.htm ... in older PHPR versions there was a functionality called "Step-by-Step" or say, Not knowing if this would really speed up things, yet as things like that are only |
admin 12/8/2023 | |
PHPRunner executes SQL query the way it is on SQL Query screen. However, PHPRunner only retrieves as amny records as it is required for the current page and it is hard to believe that retrieving 20 records can cause this kind of issue, no matter how many fields you select. Groupping and sorting can definitely be an issue with can be solved with the help of indexes. It sounds though that you are trying to guess which indexes will help and this is not how it works. Instead of guessing you need to print exact SQL queries, run them manually and see which one is slow. The following article is still extremely relevant: |
mbintex author 12/9/2023 | |
there is no current "issue". I only want to be prepared. And of course you can first enlarge the resulting dataset to more than twenty records plus all filters and where-tabs require the whole data set to be scanned, no matter if in the end only 20 records are shown. |
admin 12/10/2023 | |
Not sure if you are arguing or agreeing. The point is that slowness 99% of the time comes from slow database queries and there is a clear and defined way to fix that. |