Forms Data Controls :: Faster Loading With Data Heavy Page
Aug 10, 2010
I am trying to find the best way to have a page with a lot of data from queries to a database load faster. Looking at [URL], when viewing information about a domain, I see that their page loads and each section has a loading symbol, so the page itself displays fast and the data comes when it is available. How do they do this? Update panels around each section with a call to a Web Service? Also, Google AdWords seems to do this too when you load the Ads or Keywords tabs of a Campaign.
In my application i am getting data fROM sql server 2008.It is coming from collection of nearly 12 tables. I have to fillter this data in my application and of fillter data i have to write Xml.
my problem is that to fillter i need to that retrieve data to hold in my application and to achieve this i am using the help of dataset and datatable.But most of time when i am running application ,my application getting hang and very slow OR getting crashes.
I'm doing an ajax work where web service will return data and on client side and I am creating html table with data.I am using var (to hold string of generated html code), do string concatenations to generate table, tr and td tags and put data in it. Then I put this html table with data into a div using innerHTML. I am applying inline css in this dynamic html code.
The issue I am facing is the web service will return a huge amount of data. What I tested is even on local machine it took about 10-12 minutes to process (concatenating, creating tags putting data in table, applying css) 10000 rows. Stored procedure just take 3-4 seconds in returning data. how this in-browser processing time can be reduced ? I am doing it for speed in some wrong way ? Or is there some technique for it or some method faster than innerHTML and string concatenations ?
I have a scenario where I have two data grids (both dynamic) to be loaded onto a page. However, the data that needs to be shown on one of the grids has no dependence on the data of the other grid. So, when fetching the data, I want to fetch it in an asynchronous manner and bind that data to each of the grids individually. Currently we have a code like
GetData(ForGridOne) ; GetData(ForGridTwo);
I want to make these calls asynchronously so that in order to load the page, the time taken would be lesser. What should be the ideal way to go forward with this ? One more thing, we would be hosting the application in a portlet which doesn't support AJAX.
how can i display the last record of the table in asp.net. i have button(Cparts) on status webform when you click this two events takes place1.A pop-up window will appearon on the screen which has 4 textfield,pop-up window comming with blank fields i want to fill all the 4 fields with current/last record of the corresponding table.2.Also tranfering the primary key value (WONumber in status) of status webform into textbox of the pop-up window(CParts.aspx) which is a hidden field.here i am inserting values into different table(Cparts table) based on WONumber which is not an unique column in this tabl
I know you can do paging in gridview but is there a way which allows u to load one page ie page 1 and then when the user select page 2 it loads that page...because I will have 100,000 rows and I dont want to load all of them.. But I need to show all, so is there a way which u can do paging which allows u to load a page at a time?
Load data while Scrolling Page down with jQuery AJAX and ASP.Net.
I want to implement same thing but want to get data base on User input and implement the same. How to write Store Procedure where i can use where clause.
So, I'm trying to use form view in insert mode on a dedicated aspx page. So when a user clicks "Add New" from the main GridView page, it will take the user to an Insert.aspx page that will be in Insert mode ready to collect information.
Here's what I have so far, and all I get is a blank page when I try to run it.
when i bind first time page (10) records then primary properly bind with records and when my next 10 records load using lazy loading then the primary key not change it shows 1st records primary key
check the below code in which i am assigning assetid (primary key) but its not assigning properly...
function OnSuccess(response) { //alert('testing'); var xmlDoc = $.parseXML(response.d); var xml = $(xmlDoc); pageCount = parseInt(xml.find("PageCount").eq(0).find("PageCount").text()); var customers = xml.find("AssetSummary");
I have set executionTimeout in web.config to 3600 (which I found out that the scripttimeout will follow this value), and in the production server, I have set debug=false, session time out = 20 min. sql command time out = 1200 seconds
However, when the application is performing heavy sql task that exceed 90seconds, I got the 'Page Could Not be Displayed' error.
When I change debug=true, the application works fine. The application also works fine when I turn off the 'Show HTTP friendly message'.
im trying to add checkboxes dynamically but i get this error "Index was out of range" While Page is Loading - DataTable tablo; SqlDataAdapter adaptor; SqlConnection baglanti = new SqlConnection("server=.sqlexpress;DATABASE=Northwind;Integrated Security=sspi");
I have been asked to design & develop a page in asp.net which contains 7 tabs. Each table contains 2 Editable gridview & clicking on gridview cell should open a popup & that popup will open a new popup ( I would say nested popup). Even when I switch from one tab to another. It should hold the griddata & whenever user will finish all the operations he/she will click on save button which will save all the data contained in the tabs. The page is really too heavy. It will definitely take a long time to load as it contains gridview operations, popup related jobs, tab data & tab switching. I am finding the best way I can achieve this with an acceptable speed of operation.
I have datagrid. i loading data to grid from user control like below
[code]....
when i click the button Show child item. all the child item are displaying except one. for first child item not displaying, but one of parent items is displaying inside child grid.
it seems like previous parents data is loading to one of child record. How can i prevent that?
I was having a discussion with a co worker about some controls I implemented. He objected to my use of dynamicly instantiating controls in the code behind, because it will be slower than specifying the control in the markup. I thought he was talking about output cacheing which to my understanding only caches the rendered output of a page not the instantiated Page object. He said no its a different type of caching. Unfortunately he was unable to give me any documentation to backup the claim so I am wondering if anyone here has ever hear of any such type of caching, and if so is there any documentation on it that I can refer to.
What should be the approach while designing when you know that your page would take considerable time to load? e.g. if it has controls which are heavy & some which are lighter? Can we make use of any of the design patterns to solve this issue?
In my website for one project we have 5000+ records in sql database. If I give page size is 100 for gridview then the paze size showing 800kb in firebug net panel and it is taking 20-30 seconds to load webpage. If I give page size is 10 for gridview then the paze size showing 160kb in firebug net panel and it is taking 5-6 seconds to load webpage. If I give page size is 5for gridview then the paze size showing 130kb in firebug net panel and it is taking less than 6 seconds to load webpage. I noticed that due to heavy paze size the performance decreasing but as per my requirent the paze size should be 100 or above and the page should be load less than 2 seconds.
I designed a web page in that i'm getting the query and executing the query, if a single user enters some query then the time won't be a matter, but if more than one person is accessing the webpage, then it will make delays to execute the queries,
how can i improve the performance of this page like making the results to be displayed more faster?
I am developing a web application related to the share market, what i want to accomplish is that i want to present the user share market data that will be updated every 40 seconds. but i dont want a page refresh do do that, i wanna do it the way it happens on say facebook, in which the page is updated with new contents without refreshing the page.
I have a page that has a cascading drop down. It works perfectly when I start with an empty page and populate data to save a new row in a db table. However, when I try to load an existing row to the page, the parent is populated, but the child and cdd are not populated. During the load, I set the ccd.selectedvalue to a valid value, but by the time the page is rendered, there is no selection. I am sure it is something simple, but just don't see it.
