473,322 Members | 1,690 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,322 software developers and data experts.

Postback is Slow!!

Hello,

I have a web page with a datagrid. I'm using the built in paging
capabilities to allow paging. Each page shows 10 records.

When the page is first loaded, a thousand rows are retrieved from the db
into a dataset (on the server), and the first 10 are returned to the user to
fill the first page of the datagrid. This happens very quickly (1-2
seconds).

However, when the user clicks 'Next Page' to go to the next page of data in
the grid, the grid takes forever to show the second page (8-9 seconds). And
all I'm doing in code is changing the page index, retrieving the same 1000
rows into a dataset (on the server), and re-binding the grid to the dataset.

Running sql profiler against the database revealed that when the user clicks
'Next Page', the db doesn't get the call for 7-8 seconds.

Why does it take so long for the request to make its way from the client pc
to the server when 'Next Page' is clicked?

Thanks!!
Nov 18 '05 #1
1 3718
Hi,

1) I guess you are doing some action in your code that cause that
behavior. I suggest you will download code profiler (ants for example)
to find out where time slipped.

2) consider caching this dataSet in order to save further DB operations
and data retrieving every attempt to move to page.

3) By nature DataSet is slower from other methods to retrieve data. This
mainly due to the amount of metadata that dataset holds.

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)52-8888377
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #2

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

Similar topics

1
by: Christopher D. Wiederspan | last post by:
I'm wondering if there's a way to use javascript to disable a ASP.NET web page before it starts to postback. Specifically, here's what I'm running into. I've got a webform that has an autopostback...
4
by: David Tilman | last post by:
I've created a web application using ASP .NET that creates tables similar to Gantt charts. There are 5 tables will 180 cells each, so there are about 900 cells on the web page. I had javascript in...
3
by: catweezle2010 | last post by:
Hello, I fill a dropdown with data from sql server with vbscript. In the view on the sql server are just citynames, only one row. To fill the dropdown takes round about 4 seconds. That's not...
6
by: et | last post by:
In a procedure where a user creates a password, among other things, the password textbox returns to blank whenever a user selects other fields that cause a postback, even though they are not done...
6
by: Terry Holland | last post by:
I have an asp page that contains a user control. This control is a panel containing a number of link buttons that get displayed if certain conditions in the db are met and these conditions can...
0
by: Luiz Vianna | last post by:
Hi folks, I´m working on this for a couple of days... I configured membership for my application. I can create user, login, logout, the user screen is save and comes back when him logs back....
0
by: Gummy | last post by:
Hello, I have a multiple user controls (15) that are dynamically added to a PlaceHolder everytime the page is loaded. In a listbox on the left (in the user controls), I can select an item, click...
7
by: Tony Girgenti | last post by:
Hello. I'm trying to undetrstand ASP.NET 2.0 and javascript. When i have a button and i click on it and i see the web broswer progress bar at the bottom do something, does that mean that there...
2
by: Joe Stateson | last post by:
Not sure what is going on. I have a treeview of an XmlDataSource with cacheing enabled. With only a few nodes there is no problem on a postback, the treeview is repainted immediately. With a lot...
2
by: wildman | last post by:
RE: Gridview textbox has data check without postback.. javascript? I have a gridview with a textbox. I can set the textbox to autopostback and check for a value in a prerender event to decide if...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.