By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,454 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,454 IT Pros & Developers. It's quick & easy.

to reduce loading time of a page

P: 1
Hi guys
Iam new to .net i got an interview and i cleared 2 interviews this is last stage. They have send me scenario.pls help me out in this scenario.

This scenario involves a fictitious web-based ASP.NET/VB.NET patient registry application. The registry has several forms (also referred to as sections). The definition of the forms is stored in a relational database. The form is constructed on run-time by querying the database recursively to retrieve the form (tblSection), questions (tblQuestion), group of answers (tblAnswerGroup)**, and answer fields (tblAnswer).(all are interconnected by pk and fk)

The Problem

After several complaints from clients it is determined that some forms loads too slow (sometimes up to 15 seconds). The target is to keep the loading time below 3 seconds. The particular culprit form contains 20 questions with 50 answers.

Since this issue is holding up patient data collection at some hospitals, we want to resolve this issue within 5 days.
Oct 12 '07 #1
Share this Question
Share on Google+
4 Replies


Shashi Sadasivan
Expert 100+
P: 1,435
How about splitting the form? :P
less questions less answeres = less time!
Except now they will have to live with the fact of seeing more pages.

Any images in the page can be removed to reduce load time...

Improve the server to handle more load.

Keep those pages as pre compiled (even though they get compiled once, i believe you can put a pre compiled one which makes it even faster)

How does that sound?
good luck with your future interview
Oct 12 '07 #2

debasisdas
Expert 5K+
P: 8,127
Question moved to .NET Forum.
Oct 12 '07 #3

Plater
Expert 5K+
P: 7,872
Question moved to .NET Forum.
I would say this is more of an sql issue.
You said it is looking them up recursively? recursive is generally though of as slow. (Unless you can do folding but i'm not getting into that)
I would think it sounds like re-writing the SQL query to use inner/outer joins would be more helpful.
Oct 12 '07 #4

kenobewan
Expert 2.5K+
P: 4,871
Great they got you to work for free! Let's if they interviewed 20 people a month and get an average of 10 problems solved... Boy I am glad that I'm not in that situation - wait a minute I don't get paid here either :p
Oct 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.