473,395 Members | 1,458 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.

Speeding up page display

Hello all,

I was wondering if there is a way to speed up the rendering of a web page
to the client browser... In my case, I am retrieving about 60 - 100 rows of
data from an SQL Server and I wish to display these rows the client as I am
retrieving them (while looping). I get the results from SQL and populate a
dataset, then I loop through the dataset and add the data to an
<asp:tablecell> object on the aspx page. Part of the data I retrieve is a
URL which points to an image on the server (the image is not stored in SQL,
just the path) of which I add then add an image control to the web page. I
believe it is in this area that takes most of the time.

It looks like the client/browser waits untill the entire contents of the
table are populated (60 - 100 table cells) before it will render the page.
My question is: Is there a way to tell the browser to start showing the
images as my code loops through the dataset? I have tried setting the
response.bufferoutput to false, but it actually did not start displaying
each row as it was added - it waited till they all were added and then
rendered the page and it took longer than response.bufferoutput = true
configuration.

I was thinking of using response.flush() after every 10 or 20 loops
through the data set.... will this work and receive an increase in
performance? Thanks for any help with this matter!!!

Regards,

Troy
Nov 18 '05 #1
4 2479
No tips??!?!!??

"Troy" <ez*****@netzero.net> wrote in message
news:u8**************@TK2MSFTNGP09.phx.gbl...
Hello all,

I was wondering if there is a way to speed up the rendering of a web page to the client browser... In my case, I am retrieving about 60 - 100 rows of data from an SQL Server and I wish to display these rows the client as I am retrieving them (while looping). I get the results from SQL and populate a dataset, then I loop through the dataset and add the data to an
<asp:tablecell> object on the aspx page. Part of the data I retrieve is a
URL which points to an image on the server (the image is not stored in SQL, just the path) of which I add then add an image control to the web page. I believe it is in this area that takes most of the time.

It looks like the client/browser waits untill the entire contents of the
table are populated (60 - 100 table cells) before it will render the page.
My question is: Is there a way to tell the browser to start showing the
images as my code loops through the dataset? I have tried setting the
response.bufferoutput to false, but it actually did not start displaying
each row as it was added - it waited till they all were added and then
rendered the page and it took longer than response.bufferoutput = true
configuration.

I was thinking of using response.flush() after every 10 or 20 loops
through the data set.... will this work and receive an increase in
performance? Thanks for any help with this matter!!!

Regards,

Troy

Nov 18 '05 #2
No tips??!?!!??

"Troy" <ez*****@netzero.net> wrote in message
news:u8**************@TK2MSFTNGP09.phx.gbl...
Hello all,

I was wondering if there is a way to speed up the rendering of a web page to the client browser... In my case, I am retrieving about 60 - 100 rows of data from an SQL Server and I wish to display these rows the client as I am retrieving them (while looping). I get the results from SQL and populate a dataset, then I loop through the dataset and add the data to an
<asp:tablecell> object on the aspx page. Part of the data I retrieve is a
URL which points to an image on the server (the image is not stored in SQL, just the path) of which I add then add an image control to the web page. I believe it is in this area that takes most of the time.

It looks like the client/browser waits untill the entire contents of the
table are populated (60 - 100 table cells) before it will render the page.
My question is: Is there a way to tell the browser to start showing the
images as my code loops through the dataset? I have tried setting the
response.bufferoutput to false, but it actually did not start displaying
each row as it was added - it waited till they all were added and then
rendered the page and it took longer than response.bufferoutput = true
configuration.

I was thinking of using response.flush() after every 10 or 20 loops
through the data set.... will this work and receive an increase in
performance? Thanks for any help with this matter!!!

Regards,

Troy

Nov 18 '05 #3
1. Browser (IE) displays table only once it has all HTML for that table.
So even if you are spiting out HTML using Response.Flush browser will not
show the table until tag </table> is received.

2. When exactly do you call Response.Flush?
When you adding Row object to the Table object it does not produce HTML
right away.
HTML will be generated only on when RenderControl method is called.
And it's called almost at the end of the request.

So my point is that you are just wasting time by calling Response.Flush
since no HTML was generated.
---------------

If you want to have such behavior you got to
1. No table
2. Use inline code as you would in regular ASP (Response.Write) to produce
output.

George.

"Troy" <ez*****@netzero.net> wrote in message
news:OB**************@tk2msftngp13.phx.gbl...
No tips??!?!!??

"Troy" <ez*****@netzero.net> wrote in message
news:u8**************@TK2MSFTNGP09.phx.gbl...
Hello all,

I was wondering if there is a way to speed up the rendering of a web page
to the client browser... In my case, I am retrieving about 60 - 100 rows of
data from an SQL Server and I wish to display these rows the client as I am
retrieving them (while looping). I get the results from SQL and

populate a
dataset, then I loop through the dataset and add the data to an
<asp:tablecell> object on the aspx page. Part of the data I retrieve is

a URL which points to an image on the server (the image is not stored in

SQL,
just the path) of which I add then add an image control to the web page.

I
believe it is in this area that takes most of the time.

It looks like the client/browser waits untill the entire contents of the table are populated (60 - 100 table cells) before it will render the page. My question is: Is there a way to tell the browser to start showing the
images as my code loops through the dataset? I have tried setting the
response.bufferoutput to false, but it actually did not start displaying
each row as it was added - it waited till they all were added and then
rendered the page and it took longer than response.bufferoutput = true
configuration.

I was thinking of using response.flush() after every 10 or 20 loops
through the data set.... will this work and receive an increase in
performance? Thanks for any help with this matter!!!

Regards,

Troy


Nov 18 '05 #4
1. Browser (IE) displays table only once it has all HTML for that table.
So even if you are spiting out HTML using Response.Flush browser will not
show the table until tag </table> is received.

2. When exactly do you call Response.Flush?
When you adding Row object to the Table object it does not produce HTML
right away.
HTML will be generated only on when RenderControl method is called.
And it's called almost at the end of the request.

So my point is that you are just wasting time by calling Response.Flush
since no HTML was generated.
---------------

If you want to have such behavior you got to
1. No table
2. Use inline code as you would in regular ASP (Response.Write) to produce
output.

George.

"Troy" <ez*****@netzero.net> wrote in message
news:OB**************@tk2msftngp13.phx.gbl...
No tips??!?!!??

"Troy" <ez*****@netzero.net> wrote in message
news:u8**************@TK2MSFTNGP09.phx.gbl...
Hello all,

I was wondering if there is a way to speed up the rendering of a web page
to the client browser... In my case, I am retrieving about 60 - 100 rows of
data from an SQL Server and I wish to display these rows the client as I am
retrieving them (while looping). I get the results from SQL and

populate a
dataset, then I loop through the dataset and add the data to an
<asp:tablecell> object on the aspx page. Part of the data I retrieve is

a URL which points to an image on the server (the image is not stored in

SQL,
just the path) of which I add then add an image control to the web page.

I
believe it is in this area that takes most of the time.

It looks like the client/browser waits untill the entire contents of the table are populated (60 - 100 table cells) before it will render the page. My question is: Is there a way to tell the browser to start showing the
images as my code loops through the dataset? I have tried setting the
response.bufferoutput to false, but it actually did not start displaying
each row as it was added - it waited till they all were added and then
rendered the page and it took longer than response.bufferoutput = true
configuration.

I was thinking of using response.flush() after every 10 or 20 loops
through the data set.... will this work and receive an increase in
performance? Thanks for any help with this matter!!!

Regards,

Troy


Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Snyke | last post by:
Hi. I have a command line script which works really fine, the only problem is that it take *really* long for the first output to be printed on screen. Since I also get some HTTP headers I'm...
5
by: joethis | last post by:
I have a query that returns a resultset rather fast, but when I go through the loop to write it out to the page I get a slow display. Is there a way to speed this up?
12
by: dvumani | last post by:
I have C code which computes the row sums of a matrix, divide each element of each row with the row sum and then compute the column sum of the resulting matrix. Is there a way I can speed up the...
9
by: mfyahya | last post by:
Hi, I'm new to databases :) I need help speeding up select queries on my data which are currently taking 4-5 seconds. I set up a single large table of coordinates data with an index on the fields...
2
by: Wayne | last post by:
I am running a complex query using about 25 criteria that are entered on a query form. If any individual criteria isn't required its field is left as "*" on the form. When I run the query the...
10
by: Sarah Smith | last post by:
Hello, I am a bit of a newbie to VB.NET, but not totally new. I took the plunge recently and decided (along with my colleagues), to try to convert/port a VB6 client/server app to .Net. (I'm...
5
by: jcrouse | last post by:
I have a program that is an external viewer. It is launched with a hotkey from within another application. The program has 30 labels that can be displayed. Since the labels may not always be...
5
by: Erik Lautier | last post by:
I have two subroutines that are running on virtually every page of my site; it's an if/then/else situation where one runs if the user is registered and the other runs if the user is a guest. I...
11
Claus Mygind
by: Claus Mygind | last post by:
In an effort to make my apps run faster, I have started to embed a search feature into the html page with javaScript to call and execute an ajax routine. Everything works fine except for setting...
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
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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:
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.