2. PHPRunner General questions
  3. [SOLVED]  Very, Very slow list page to load
This topic is locked
[SOLVED]

 Very, Very slow list page to load

 		12/30/2013 4:33:45 AM
PHPRunner General questions
S
 swanside author

Hi all, and a Merry christmas before I start.
Just need a bit of advice on fault finding, On some of my pages, they are really slow to open.
I can go into PHPMyAdmin and open table in there, like the one in the picture, and it will load within a couple of seconds, but when I go to my project and the same table in the list view, it will display the table, but will stall for about 1 minute with Loading displayed






I have a quicktime recording, and it takes about 1m and 13 seconds from clicking on the link to the page being ready for adding or altering.
Are there any fault finding techniques I can use to see what is taking so long for this page to open?
Cheers

Paul.
Sergey Kornilov admin 12/30/2013

Yes, start here: http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/
S
 		swanside author 12/30/2013



Yes, start here: http://xlinesoft.com/blog/2011/04/08/improving-perfomance-of-phprunnerasprunnerpro-applications/


Brill, Thanks, just what I was looking for.
Cheers

Paul.
S
 		swanside author 12/30/2013



Brill, Thanks, just what I was looking for.
Cheers

Paul.



I think I need to do some work on this
Sergey Kornilov admin 12/30/2013

Yes, you need to find all SQL queries executed on that page and locate that one or those few that make your page slow.
S
 		swanside author 12/31/2013



Yes, you need to find all SQL queries executed on that page and locate that one or those few that make your page slow.


Ok I have even now gone as far as only having a few lines on the page and nothing linked to cross tables, but it is still slow to pad.

What I did notice is the page size is about 220Kb compared to 88kb on a page that has more information in it.

Any ideas as to why this would be?







Cheers

Paul
Sergey Kornilov admin 12/31/2013

You have to go through that article one more time checking all possible reasons. The page size is still relatively high and you need to figure out what exactly causes this.
If you want someone from our support team to look this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Providing a meaningful advise based on these screenshots is not possible.
S
 		swanside author 1/8/2014



You have to go through that article one more time checking all possible reasons. The page size is still relatively high and you need to figure out what exactly causes this.
If you want someone from our support team to look this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Providing a meaningful advise based on these screenshots is not possible.


OK, Sorted now <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=73553&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Removed the search panel and just used ajax searching. The page size went from over 230kb down to 10kb and load went from over 16 seconds down to 1.27 seconds
Cheers

Paul.
Just checked again, and its like lightening. Can not say how much happier I am now. Great stuff. Thanks ever so much for the link above for checking and helping out.