This topic is locked

Measuring loading time

3/7/2011 4:58:46 PM
PHPRunner General questions
L
langemand author

Hello Forum.
Users of my database application sometimes encounter that pages take a long time to load.
To investigate and document this, I'd like to save a start time (the page is ready for loading) and an end time (the page is finished loading) and store these in a table.
Is this possible - and how?

T
tedwilder 3/14/2011

I have exactly the same problem : I use phprunner on intranet, It's very very slow.

for instance on list page it says " Loading.." but what annoys me is that datas under the flash " loading" thing is there.. So I dont even understand why it's asking us to " wait "...

So I might buy Nucoder to compile phprunner but Im not sure I will gain speed. (any one tried to compile phprunenr projects ? )

langemand: I dont know what kind of database server you use, But if it's mysql you can get mysqllog : it will show you what requests have been made, at what time and how long they took to proceed. ( try to dl the mysql GUI suite from mysql website).

P
procheck 3/14/2011

If you display the "loading" message remove it (in Misc I think) and you will see significant improvement.

L
langemand author 3/14/2011



langemand: I dont know what kind of database server you use, But if it's mysql you can get mysqllog : it will show you what requests have been made, at what time and how long they took to proceed. ( try to dl the mysql GUI suite from mysql website).


My fault, I should have given some more information.
It is MySQL, but at a Web hosting service. The only access I have is using phpMyAdmin and then of course PHP.
My PHPRunner version is 5.3 (7113).
The experience I have is that the application takes about 10 seconds to start up (load the login page). First page then loads at approx. 5 seconds - subsequently the loading time is two to four seconds. To my way of thinking, this is okay, but as I said, there are users who are experiencing something else.

Admin 3/14/2011

As a simplest method you can use Firefox with Firebug installed in order to measure page load speed. You can see how long server-side processing takes what else is loaded and how long does it take.
I want to point that 'Loading' box itself doesn't slow down the loading process. It simply indicates when page is ready i.e. all javascript, CSS and images were loaded.
Slow load indicates that there are problems with project setup like ineffective database design or a search panel with hundred of fields or a huge dropdown box on the search panel. If yo have a project that runs slower than it should contact support to get help.
A sample screenshot of Net tab in Firebug.

T
tedwilder 3/14/2011

hello thanks for the tip on "removing loading".

concerning log check ,fine tunning etc, I have under 7 euro/month a usa host that allow me to have as many database as i want + ssh login unlimited storage space and unmetered bandwith and I can connect with my login with mysql bench suite to get all mysql server info and change what I want. Im not sure I can tell here the name of my host compagny but it's the best I 'v ever try ( since 1997 I tested around 13 hosting compagny).

P
procheck 3/15/2011

Sergey,
While the 'Loading' box itself might not be the problem, I did notice a significant improvement when not using it, even on a local web server. I haven't tried debugging this to see why this is happening. Maybe the data which cannot be seen is still loading. I can access the record much quicker when I don't use it. Has anyone else had a similar experience?
Al
P.S - Ted, I hope I'm not hijacking your thread.

Admin 3/15/2011

Al,
if page is not fully loaded some features that require Javascript may not work. Its true that users can see data faster and access some functionality with Loading indicator even if page is not fully loaded.
Its your decision to keep or to remove 'Loading' box. Depends on your app and who your users are.