473,395 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

to reduce loading time of a page

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
4 1855
Shashi Sadasivan
1,435 Expert 1GB
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
8,127 Expert 4TB
Question moved to .NET Forum.
Oct 12 '07 #3
Plater
7,872 Expert 4TB
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
4,871 Expert 4TB
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

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

Similar topics

181
by: Tom Anderson | last post by:
Comrades, During our current discussion of the fate of functional constructs in python, someone brought up Guido's bull on the matter: http://www.artima.com/weblogs/viewpost.jsp?thread=98196 ...
3
by: Roy Wang | last post by:
hi, My problem is how to determining when the XML file has loaded using javascript. I loaded an xml file using javascript in a web page. The code below is loading the xml file for IE:...
4
by: Adrian MacNair | last post by:
Hi, I created an image gallery which displays 63 images in a slideshow. The problem is that the show was slow because each image loaded one at a time during the show. No problem right? I just...
6
by: Sean C. | last post by:
Helpful folks, I am having a hard time figuring out how to reduce my percentage of dirty page steal activity. Below are statistics for three fairly normal days, with the bufferpool hit ratios...
6
by: Curious George | last post by:
I have a page that takes about 10 seconds to load the first time it is run. I would like to first display a little animated gif telling the user that the page is loading. How do I do this with...
2
by: Jean Pierre Daviau | last post by:
When I have something like this in a js file. listeImg = new Array(); listeImg = new Image(w,h); listeImg.src = "centre1.jpg"; etc Are the images loaded after the page is loaded? In the same...
4
by: objectref | last post by:
Hi, i found on the net something that it has to do with the large working set of a .net application, describing the process of the CLR loading and all this stuff. It seems that every time CLR...
5
by: =?Utf-8?B?V2FubmFiZQ==?= | last post by:
We have a page that is loading very slow. There is not a lot of data, not a lot of users are connected at the same time and the page does not produce an error, so I am not sure where to start to...
0
by: AndySummers | last post by:
Hi We have just re-written a majour asp.net project to use a user control embedded in a web page. The main dll references 3 other custom controls and so to deploy the project I copy the 4 dll's to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.