I built a ASP pages which displays data from a big database from SQL server, I used system DSN to access the database, I know of course that there are a lot of stuff that are not efficient, such as repeated access to read database instead of store it in a local variable.<BR><BR>I found problem when there are lot of users of the page, it become halted (suspended), when number of users reduce, it become normal again. I am new to ASP, can someone tell me is it related to the multiple access to database or sth else that effect the performance? (I don&#039t think local variable or DSN issue will cause such severe problem.<BR><BR>Please give your help!!!<BR><BR>Janet