What should I do if the aspx page opens slowly?

myhopen

The webpage I made with vs2005 seems to open slowly, and the server and network are not bad. The simplest page does not have any code. There are only three controls. You have to wait for it to open. Is there any way to speed it up?
There is connection.open () and connection.close () will not affect speed?
My index page needs to execute almost 10 stored procedures. In this case, should I execute close after 10 stored procedures after conn.open or open and close once for each stored procedure?

德鲁伊

The first time is slower, it won't be later, unless the webpage does have a problem

天羽魅力

Use caching! Put the database operations in the server's cache, this will be a dozen times faster

qyqy0616

Is it better to open and close each time a stored procedure is executed!

xing_532

Optimize the data access method, it should be slow to read data

天羽魅力

Also, every time a web page is connected.open, it must be remembered close! Otherwise, the server will be exhausted!

aaajet

You put the code to access the database into the constructor to execute,
There will be significant changes in speed, but what are the consequences, I do n’t think I need to say more
There are advantages and disadvantages, you measure it yourself

jys5090

The first time was of course slow.

myhopen

Why is no one answering the latter question?
Is it one open, close or 10 open, close ???

hahahoho

1 time

Make no mistake