Interview Q

[kumarangopi]

One of my interview asked me "You develop a website and give it to client.Later client informs you that website is slow,what will you do?" any answers?

 

[ss7thirty]

I would need more information. What kind of site is it? ASP.NET, HTML, PHP? Then I would need to ask what type of server is it running on? How much traffic is it getting? Are there any large image files on the site or other downloads when a user accesses it? Are there any DB connections? You can go on and on until you find the correct answer. But I do not think that question can be answered easily, the interviewer was looking for an in depth explanation of the questions you would ask about the site to gather more information in order to begin finding the problem and eventually the solution.

 

[kumarangopi]

I would need more information. What kind of site is it? ASP.NET, HTML, PHP? Then I would need to ask what type of server is it running on? How much traffic is it getting? Are there any large image files on the site or other downloads when a user accesses it? Are there any DB connections? You can go on and on until you find the correct answer. But I do not think that question can be answered easily, the interviewer was looking for an in depth explanation of the questions you would ask about the site to gather more information in order to begin finding the problem and eventually the solution.

Lets say ASP.Net with SQL Server 2005,will we able to tell answer with these two parameters

 

[ss7thirty]

The first thing that I would ask is the ammount of traffic and the content of the website. Then I would ask if you are loading large ammount of data to a datagrid or anything like that. Secondly, I would ask if you are using a dataset to load data because often this is significantly slower than a data reader. Next I would ask about the sql server are there any indeces, etc that could speed up selects. What type of queries are running when the site loads. If none of these things could speed the site up I would have to look further in the code and find the exact location where the code is taking a long time and I would pinpoint the exact location in the code where it was breaking and take it from there.

 

[alander]

I would ask how is the data being access..

I would recommend stored procedures if pure sql statements are used in codes..

Next I would ask what kind of connection is the client using.. Is enableViewState necessary for the asp application? If no, we can safely disable it in the page directive to reduce the network load

Are there and pictures? if yes we use can thumbnails

u can think of more that will reduce the network load.. the above are some examples