Web Forms :: How To Optimize Page Load With Expected 3K Records To Display
Feb 1, 2011
I am looking for a way to improve user experience on a UI that can display on average 3K records in the Grid. Today's implementation limits grid on the page to 20 records with a "Next" option to continue through the data. Requirement is to load all of the available data in one shot and allow Sorting, Filtering, etc.
I have a web page which has about 11 gridviews.Hence the page takes bout 15 seconds to load.The grids are 1 below the other.They are populated at the page load.
I need a solution to reduce page load time. Is there a way,where the gridview loads only if user scrolls to it. I donot want the user to make selection for everytime he wishes to see a gridview. The page should show gridview if its data is bound to it, not waiting for entire page gridviews to get populated.
I wanna bind atleast 30,000 records in a gridview from a sqlserver table. I want to bind only 50 records at a time with grid view. The grid has also paging and when I click next page then next 50 records should be shown and another next page's click another 50 records.
How can I optimize this thing. I want that If 30,000 records are binding then grid should be work as binded 50 records.
basically, the InstellingGegevens table gest filled in by some procedure from another server. the thing i then need to do is check if there are new records in this table, and fill in the new ones in Instellingens.
this code runs for like 4 minutes on 15k records. how do I optimize it? or is the only way a Stored Procedure?
this code runs in a timer, running every 6h. IF a stored procedure is best, how to I use that in a timer?
I have a webpage which displays content drawn from a single record in a database table. I've been asked to change this so that the content displayed alternates between 2 records each time the page is requested by a browser (I guess this would equate to each PageLoad event).
The records to be displayed are chosen on the basis of two dates, a beginning date and and ending date, that define a time period in which the record is to be active. The table containing these records has 2 columns containing these dates (begin date is contained in "dtDisplay" and end date is "lastDisplay."
I'm not sure how to amend the existing code behind to make this happen. Here is the c# that I inherited from a developer who is no longer available.
I have a data grid in which I have to display around 12,000 records. Even if I do paging it is difficult to display all the records. Is there any other control or something else so that I can display all these records. Even if I make these as alphabetical also, some times I have to load 1000 records in a page which is difficult.
i have 4 dropdownlist controls in a page. each have more than 6000 records. when retrive the records from DB there is no issue and taking very less time. after getting the records it takes too much time to display in the the page. here no problem with db retriving.. i guess problem is with page weightage. how can i solve this problem..
I am trying to get my repeater to display information 10 records at a time for a single page with the user having the option to press next to view the next 10 pages or previous to review the previous 10 records with the option to skip pages by clicking the navigation links 1 | 2 | 3 | 4 | 5 is this possible?
Does it have to be alot of code as I have done it sort of already with an array and 5 repeaters? do arrays such as string a work when being hosted?
I have requirement like to display the Master details records in the page, without clicking the parent record (for getting ID to retrieve the detail record) i need to display all the child records in between the Master records while page loads.
I am working on displaying records in grid view. I have a dropdownlist on top of the grid and has items as 5 results per page, 10 results per page and 25 results per page. I would like to display only that many set of records per page as chosen from dropdownlist . I have tried this but don't see any change when i chose different options ..
<asp:DropDownList ID="ddlDisplayPerPage" runat="server" Height="22px" Width="155px" onselectedindexchanged="ddlDisplayPerPage_SelectedIndexChanged" AutoPostBack="True"> <asp:ListItem Value="5">5 Results Per Page</asp:ListItem> <asp:ListItem Value="10">10 Results per Page</asp:ListItem> <asp:ListItem Value="25">25 Results per Page</asp:ListItem> <asp:ListItem Value="50">50 Results per Page</asp:ListItem> </asp:DropDownList> protected void ddlDisplayPerPage_SelectedIndexChanged(object sender, EventArgs e)
In my web application, I have used AJAX Toolkit and my .net version is 3.5. When I run the application and save the page, so many ScriptResource.axd and WebResource.axd generate which makes the file size 200 to 300 KB more big. After doing the same procedures mentioned in the above link, it was working fine as all ScriptResource.axd and WebResource.axd file is removed.
But when I go from one page to another page using on click, then Object Expected Error comes and when I debug it,I found one ScriptResource.axd file containing query string like .axd?d=-bA.like this and Request. GetResponse cannot find the file and it gives 404 errror (File Not Found).
We have one Asp.net application developed using framework 2.0 with C#,Sql and AJAX. The application is running live from past 2 years almost. All the times users will be facing kind of strange problem, reporting some junk data will be displayed on the browser some times. When they refresh the page or reopen the browser, it will display the correct information.
For Eg. We have a stored procedure which returns months between 2 dates, if we pass 2 dates as '01/04/2010' and '30/06/2010' then procedure will return 'APR,MAY,JUN'.
Once case we have noticed where it has returned and displayed as MAY,JUN,JUL,AUG which is not possible. Once we refresh or reopen the page it displays the correct information.
This is one ex. whereas we have some other page also where we get unwanted values like that.
Actually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
I have an issue that I've spent quite a bit of time trying to solve. I have a Detailsview and a Gridview that I have linked using the ID field, It has now been decided that they want to have individual pages for each Unit. I have this working for the most part, however the detailsview is not being displayed until I hit select the row in the gridview.
How do I get this to automatically display on page load?
I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.