Page loads slowly

[hoz]

Hi ,
I have a problem that i cant understand . Let me explain a bit : i am trying
to develop an e-commerce website with using mssql and c# .
i use three tier app development.
1 - Sql procedures : to retrieve informaion from db (mssql)
2 - Classes that encaplusates db transactions ( calling procedures)
3 - user side .
lets say if user clicks get my info
UserClass myinfo = new UserClass();
repeater.datasource = myinfo.GetMe( userid); repeater.databind()
but it takes noticable time. I create indexes for db tables , used
procedures , used class .
on local machine , it is ok but for internet , it seems so slow . What can
i do ?
thanks

 

[Peter Rilling]

First, make sure that the database is returning data quickly. Run the
stored procedures independent of the website and see how quick it takes. If
the site runes normal on your local machine, it probably is not an issues on
the internet.

Next, take a look at the amount of data in your page. If it takes a long
time to load, it might be that you are sending too much information to the
browser. If you need to display lots of records, consider some form of
paging. Also, you can usually reduce the amount of data by removing
unnecessary whitespace from your ASPX file. For instance, although tabs are
beneficial for reading the HTML structure, they are not necessary for the
browser. For each whitespace, it removes that many bytes from the output
(which is a lot if you have hundreds or thousands of records being
displayed).

 

[bruce barker]

check the size of your viewstate (or turn if off for your page). you payload
is probably too great for an internet site

-- bruce (sqlwork.com)



| Hi ,
| I have a problem that i cant understand . Let me explain a bit : i am
trying
| to develop an e-commerce website with using mssql and c# .
| i use three tier app development.
| 1 - Sql procedures : to retrieve informaion from db (mssql)
| 2 - Classes that encaplusates db transactions ( calling procedures)
| 3 - user side .
| lets say if user clicks get my info
| UserClass myinfo = new UserClass();
| repeater.datasource = myinfo.GetMe( userid); repeater.databind()
| but it takes noticable time. I create indexes for db tables , used
| procedures , used class .
| on local machine , it is ok but for internet , it seems so slow . What
can
| i do ?
| thanks
|
|