Performance issue ....Pls help me ...

[Ankur Bakliwal]

Hello all, I m using 12 SP, 7 include files in a ASP file. Now problem is that, that page is not opening or its takeing 2much time to open & some times my server shows 100% CPU usage. What should i do to make it fast?????? ;)

Thanks, Ankur Bakliwal

[andyharman]

It is unlikely to be the includes - I often have ten or more. Can you add timing code around the stored procedure calls to confirm how long each one takes?

[Guffa]

You should start by identifying what part of your code it is that is taking time. Nothing of what you mentioned gives any clue to any performance problems.

--- single minded; short sighted; long gone;

[Guffa]

andyharman wrote:

It is unlikely to be the includes - I often have ten or more.

I actually tested the performance of include files a few years ago. It showed that you can have a hundred include files without any noticable performance hit.

--- single minded; short sighted; long gone;

[Ankur Bakliwal]

Yes, I have added 4 iFrames also in that page & that pages also have some SPs I m not able to find out that part which is takin time..

Thanks, Ankur Bakliwal

[Ankur Bakliwal]

Thanks for the response. Please confirm the include and iframe sequence which are being used in the main page. The page has 4 tabs, which are used to call 4 different pages. Response.buffer=false For case 1 to 5 Case 1 then include page 1 and activate the tab (by display: none) Case 2 then include page 2 and activate the tab (by display: none) etc Page 1 has 3 include pages 4 iframes and each iframe has one page for ex. loadme frames src is a dds.asp?id=10 the dds.asp has response.buffer= true and response.flush() Yes, the sp are not taking too much time. it will take from 40 sec to 70 sec. Please look into the above sequence and correct me if i am wrong.

Thanks, Ankur Bakliwal

[badgrs]

Add some timing code round all the SPs and any other logic thats pretty intensive. Try loading the iframes seperately and see how they cope, although the page should load before the iframes so I imagine they won't make a difference. Failing all that, ditch ASP, it sucks plain and simple.

[Guffa]

Why are you turning off buffering? Normally there is no reason to do that. Still, there is nothing in what you describe that should take 40 seconds to execute. Is it the page containing the iframes that takes time to load, or the contents of the iframes?

--- single minded; short sighted; long gone;