Take time to load the page of asp.net

Question

1.00/5 (1 vote)

See more:

I have 2 drop down having a record of around 10000 each and a datagridview of 11000 record which is run using paging. No problem with code.

When i run this web application in a live server it will run fast but when i run in some workstation it will take time to load the page.

As i have seen the log all the page load event have executed sucessfully but it will take time to show at workstation.

Can you suggest me where is the problem.

Posted 3-Aug-15 2:58am

Member 3623312

Add a Solution

Comments

Abhipal Singh 3-Aug-15 9:12am

Well, 10000 records in a drop-down is itself a fishy thing(I don't know how user friendly it is), however, as you said there is no issue on the server I take your word.
I have a question, Is this a Development workstation (with hosting server and client on it)?
If yes, would suggest you to check the vitals of your workstation. Like, how much RAM is in use, processor usage and disk usage when you open the webpage. May be, your workstation is not good enough to handle the load of server and client hosted on same machine.

Member 3623312 3-Aug-15 9:18am

No, server and workstation PC is different.

2 solutions

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)

F-ES Sitecore · Answer 1 · 2015-08-03T03:12:00

The problem is that you have dropdowns with 10,000 records and a datagrid with 11,000. This information is too much for any human being to process and it is always going to result in a slow site. Replace the dropdown with an auto complete feature so the user only sees records they type for, and restrict the data in the grid to only relevant data also (again you might need a search\filter function or it could run off of what is in the auto complete box if necessary).

IamWsk · Answer 2 · 2015-08-03T03:10:00

Solution 1

It might take time at binding
So use sql dynamic quries asp.net dataset binds data faster from dynamic quires

Its Called SQL Parameter Sniffing

For Example :
declare @parameter as varchar(max)

set @parameter='Select * from Table'

exec @parameter

Posted 3-Aug-15 3:10am

IamWsk

Updated 3-Aug-15 3:12am

v2