2 nuclear CPU, 2 gb of memory, speed of 2 m,
The DataSet DST=db. ExecuteDataSet (CMD); Return to a more than 200 data with the use of more than 10 seconds slower 20 seconds when

After the debugging
SQL statement select * from TheLaw order by OrderBy 0 seconds
The DataSet DST=db. ExecuteDataSet (CMD); 10-20 seconds between
Binding tree
1 secondsEnclosing view state (" ds ")=ds;
AddTree (" ", (TreeNode) null, "");

Because of the slow reaction, I added the server cache
System. Web. The HttpRuntime. Cache. The Add if cached will save the DataSet DST=the ExecuteDataSet (CMD);
Results 1 seconds,

Add a caching section fix (problem analysis)
Bandwidth issues
Two kinds of circumstances access speed, the same should not be bandwidth issues
Memory problems
The second increase memory storage faster instead, should not memory problems
CPU problems
That only CPU problem, CPU is E5-2682 2.50 GHz, by definition, pull 300 data shouldn't be so slow ah,

Have a great spirit experience? Is this why? The problem is U? Or memory problems, or network problems, understand the people under the guidance of the

CodePudding user response:

CodePudding user response:

CSDN decline? To explore the person all have no,

CodePudding user response:

ExecuteDataSet method is what, haven't seen the

CodePudding user response:

May be a code problem, if the memo field is not needed, the change, had better select statement written
Select the field name instead of select *

CodePudding user response:

This is not a light to see problems,
First of all,
1 loading the DataSet, need time,
2 what is ExecuteDataSet method, we also don't know,
3 network whether unobstructed,
And as for you said cache, actually not count,
Because he almost ignored the 3 steps above,
You didn't really find out why,

CodePudding user response:

Your web server to less, the database server and application three systems, who you can distinguish the foot out of the question?

CodePudding user response:

reference 5 floor is nu month god reply:

this is not a light to see,
First of all,
1 loading the DataSet, need time,
2 what is ExecuteDataSet method, we also don't know,
3 network whether unobstructed,
And as for you said cache, actually not count,
Because he almost ignored the 3 steps above,
You didn't really find out why,

How long can you stay 266 cartons of the dataset
ExecuteDataSet is dbhelp in one way,
Network must be unobstructed!
Cache is to use network

CodePudding user response:

refer to 6th floor xuzuning response:

your web server to less, the database server and application of three systems, who you can distinguish the foot out of the question?

The database server directly checked 0 seconds,
Filled in the cache server is 0 seconds
Application is a web page so I change clothes is the problems of slow network or usb,

CodePudding user response:

The

reference 27th Bug reply: 3/f

ExecuteDataSet method is what, haven't seen the

Public virtual DataSet ExecuteDataSet (DbCommand command command); Microsoft DBHELP provides methods, this no problem for certain, 5 m speed 4 nuclear before U, tens of thousands of article is no problem

CodePudding user response:

refer to 7th floor curiosity is to learn response:

Quote: refer to fifth floor is nu month god reply:

this is not a light to see,
First of all,
1 loading the DataSet, need time,
2 what is ExecuteDataSet method, we also don't know,
3 network whether unobstructed,
And as for you said cache, actually not count,
Because he almost ignored the 3 steps above,
You didn't really find out why,

How long can you stay 266 cartons of the dataset
ExecuteDataSet is dbhelp in one way,
Network must be unobstructed!
You also want to use web caching

If not test, loading no problem how to prove?
How many columns you row data, we also don't know,
Since you said the cache only 1 second, instead of a cache is 10 to 20 seconds,

Can I also speculate that the cache is read and loaded the dataset time? (because of your SQL query time soon, so negligible)
So slow, need test load and loading time?
The problem further, to see whether the network is obstructed or not?

We screen problem, want to see the actual test, rather than we think good is good,
Or you tell me, what do you think you are slow?

CodePudding user response:

refer to the eighth floor of curiosity is to learn response:

Quote: refer to the sixth floor xuzuning response:

your web server to less, the database server and application of three systems, who you can distinguish the foot out of the question?

The database server directly checked 0 seconds,
Filled in the cache server is 0 seconds
Application is a web page so I change clothes is network slow or U

In front of you just reply me that network unobstructed,
Now say again doubt network slow,,,,,,,