How can i calculate time occur in fetching data from Server.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hello Dear Friends I want to show seconds in my asp.net web page that is occurring in fetching data from sql server please help me. for example in google when someone searches any term google will display something and displays seconds took in fetching data from server.

Posted 11-Jun-11 4:50am

Satyendra Kumar(Analyst Programmer)

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DaveAuld · Accepted Answer · 2011-06-11T05:34:00

Solution 1

In the code behind you could employ a Stopwatch which is part of System.Diagnostics;

Start the stopwatch immediately before the fetch begins, and stop it when complete. Then just look at the elapsed time for the operation.

See this link for the documentation on StopWatch system.diagnostics.stopwatch[^]

Posted 11-Jun-11 5:34am

DaveAuld

Comments

Satyendra Kumar(Analyst Programmer) 11-Jun-11 13:26pm

watch.Start();
BindData();
watch.Stop();
TimeSpan ts = watch.Elapsed;
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
ts.Hours, ts.Minutes, ts.Seconds,
ts.Milliseconds / 10);
lbltime.Text = "RunTime " + elapsedTime;

Is this ok dear or not please tell me.

DaveAuld 11-Jun-11 13:28pm

I don't know, try it and see! Basic theory looks fine :-)

Satyendra Kumar(Analyst Programmer) 11-Jun-11 13:32pm

it is working but i am not sure that it is right one or not

DaveAuld 11-Jun-11 13:33pm

What do you mean if its the right one or not?

Satyendra Kumar(Analyst Programmer) 11-Jun-11 13:41pm

It is checking right fetching time or not BindData() is my function that is fetching Data from Database.

Sergey Alexandrovich Kryukov 12-Jun-11 0:31am

Correct, my 5 (I strongly disagree with the one who voted 1, fortunately, the vote of this member weights very little next to mine :-)
--SA

Satyendra Kumar(Analyst Programmer) 12-Jun-11 2:47am

what you want to say please explain your answer is this is right code to check fetching time or not

DaveAuld 12-Jun-11 2:51am

Providing your BindData() is not doing a ton of other stuff, yes it is. What you need to ensure is that to time the fetch operation, make sure the stop watch is started and stop immediately before and after the db operations.

Satyendra Kumar(Analyst Programmer) 12-Jun-11 2:59am

how can i determine that it is starting at right time or not. If possible please give me some code example so that i can understand exact.