Data Controls :: Website Performance Decreasing Due To More Records In GridView
Apr 1, 2012
In my website need to display 5000+ records in gridview. So, I used custom paging for static page bar and displaying 100 records per page. In stored procedure using ROW NUMBER() keyword to retrieve specific records from the database. Even though website is running dead slow. Is there any alternate way apart from the ROW NUMBER() to increase the website performance. I followed the below article to achieve custom paging.....
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 have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
I had created a web site with asp.net and sqlserver. How can i improve the my website's performance in with regard sqlserver connection?What's your mind about use pool connection? In this regard what the defualt values is set for 'Max Pool Size' and 'Min Pool Size'?What's your mind about use Asynchronous access to data? What's your mind about other ways that you think?
I am using gridview. In which i m entering some value in textbox in Gridview.According to that value, i m generating datatable and binding it to the Gridview(Child Gridview).But when i m doing this, the performance of the page is very slow. How do i improve the performance.
I am trying to speed up a Gridview on my page that reads 8,000 records using an AccessDataSource. So I am trying to implement caching. I have used the information given here: [URL] but it has made no difference in the response time. Can anyone direct me on this? Is there something you have to specify in the gridview (besides the datasource). Would it work if I went to SQL Server?
This is my AccessDataSource code. You can see the 3 relevant lines starting 6 lines from the top.
I have developed a application using Visual Studio 2008 and SQLServer 2008. I have a page called "Billing Center" where i need to display more than 500 records in a gridview and the gridview has sorting enabled. If i limit the page size upto 10 only the gridview performs well but user requirement is to view atleast 500 records at once which is slowing down the gridview record retrieval process.
I am using the following C# code in code behind to sorting, paging and retrieval . Please guide me what am i doing wrong in this code and how to make it work with large data set.
Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality .I would like to save all the dynamic row data generated from GridView1 into the main GridView2. The data from GridView1 are not saved in the database, while the data from GridView2 are.
This means the after refreshing the page, the GridView1 data disappear, and the user is able to add new rows with data. The point is to transfer the GridView1 data to the main GridView2 with a second Add Button. If data from GridView1 are saved into database, how to hide previous record in GridView1 from the user after adding data to the second GridView2?
I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
I have a gridview that shows all data from a table. DataNames includes KeyId, which is a Primary Key.Yet when I try to delete a record, nothing happens, the page appears to performa refresh but the record is still there.Edit does not work either. I used the wizard to build all of the queries, they look okay. But I cannot figure out why they are not working.
m using gridview to display records from sql server2005. In gridview, I have a field containing checkboxes. Now what i want that the fields against which a user checked in checkboxes that will be deleted by clicking on delete button just like the emails yahoo, gmail etc How can i do so?
I want to create 2 columns and 5 rows and want to give heading to those 2 columns and would like to manually enter the values in the rows, how ? (I don't want to connect this gridview with the database)
I habe a arraylist that can pass in the result of a quiz and once the user finishes this quiz, the result will be displayed in a gridbiew which is binded into a sqldatasource. In this gridbiew, there is this column which will highlight the the result of this qn which displays correct and incorrect. what i want to do now is, i want to count the number of correct answers. I want to count all the correct answers and bind it to a label in the same page.
have a textbox to get the customer name , and i need to get the name from a dialog modal that have a grid that i can search from costumer table the line that i need... And can pass to my text box only the name of the costumer.
I have written a code from here http://www.aspsnippets.com/Articles/Display-GridView-with-Empty-Message-and-Header-and-Footer-when-no-data-in-ASP.Net.aspx. I just edited this as follows. this is my gridview code:-
and my code file code is as follows SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Bind_Grid(); } } protected void Bind_Grid() { string strSql = "select * from mtblInformation"; SqlCommand com = new SqlCommand(strSql,con); SqlDataAdapter sda = new SqlDataAdapter(com); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { gvCustomers.DataSource = dt; gvCustomers.DataBind(); } }
when in database table have records then gridview binds and its showing records, But when there is no record in DB , instead of showing msgs that "No Data found." gridview doesn't appear.
