How To Improve Performance Of A Gridview
Feb 16, 2011
I have developed a gridview which has displays 8,000 records. However, the user is compaining that it is too slow. A major function of this gridview is to filter on two of the columns. It seems to me that if the records were stored in memory it would be much faster. This is caching, I think. Is that the case? Since filtering is being done I don't think custom paging will help much. When they submit a filter, with custom paging wouldn't the entire table be read again? So I was thinking of trying caching which is available on SQL Server. Am I on the right track? Can you cache with an Access database? Can you think of any other ways to improve performance of a gridview?
View 1 Replies
Similar Messages:
Feb 17, 2011
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.
[Code]....
View 1 Replies
Mar 30, 2011
My scenario is : WebApp -> WCF Service -> EDMX -> Oracle DB
When I want to bind grid I fetch records from Oracle DB using EDMX i.e LINQ Query. But, this degrades performance as multiple layers take place between WebApp & Oracle DB. Can I use caching mechanism to improve the performance? But as far as I know cache is shared across the whole application. So, if I update cache other user might receive wrong information. Can we use caching per user? Or is there any other way to improve performance of the application?
View 2 Replies
Jan 20, 2011
regarding the performance improvement in Asp.Net?The best practise tips for asp.net performance improvement?
View 4 Replies
May 5, 2010
I have one online school management application developed on asp.net 3.5 using Linq,
Now in my database i have main three talbes which uses in many store procedures,functions,linq join query
CourseMst - Master Table Have CourseID P.K.
StudentMst - Master Table Have StudentID P.K.
Student_Course - Child Table Have StudentCourseID P.K
StudentID F.K. Reference To StudentMSt
CourseID F.K. Reference To CourseMSt
Now i want to increse speed of my application for those page which have query or sp related to above tables,
I want to know about indexing procedure that how to apply indexing and on which field i have to apply indexing
View 5 Replies
Aug 7, 2010
I see bugs? give me your opinion really improve my site es [URL] this is metasearch fly meta search flights
View 2 Replies
Jul 14, 2010
I am working on finance domain, we are using many sessions and viewstates for store values and data. Our clients want fast speed of our website. We are using grid/repeater/datalist and chart controls for show data.
View 3 Replies
Jun 3, 2010
I am working on AJAX-ASP.NET site. This site is taking 25-30 sec to load the contents. I want to improve this site performance. Is there any settings required in IIS? How to check IIS log files?
View 2 Replies
Feb 17, 2011
I am a .Net Developer and I develop using C#. I am always but all business logic at separat Class Library project , and then use it with my project, But I want to know if it will improve the performance of application , or I can but the Business logic class within the main project without effect at the application performance?
View 2 Replies
Jun 5, 2010
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?
View 3 Replies
Dec 17, 2010
how to improve the application performance while writing LINQ Queries ?Like the optimization techniques.
View 2 Replies
May 14, 2010
I am having trouble with the performance of a web site... Some SQL queries are killing the server. But, as the title of this post mention, I looked at the OutputCache page directive to improve performance of the site. Although, I came across some questions regarding this directive:
1- If I have a web-user control that declares an OuputCache directive in a page that has one too, which one will "win"?
2- What's the best pratice regarding the duration ? I'd love to have a sliding window too.
View 2 Replies
Mar 21, 2010
I have a select query where iam fetching the data from minimum of 7 different tables by using innerjoin. I have 3 lakhs of records in that table.BY using cache Iam fetching all 3lakhs of records at a time and put in cache. by using the rowfilter i use the records.firsttime when iam fetching these 3lakhs records it takes 3min. want to improve the performance of time.How to improve the performance of time?
View 1 Replies
Feb 3, 2010
I am using Sql server 2005. I have a stored procedure, which has a select statement to retrieve thousands of data from the table.
The time taken to execute is longer and hence affecting the performance.
[Code]....
Here, id is the primary key. Clustered Index is also set.
How to improve the performance of the stored procedure?
View 13 Replies
Feb 2, 2010
I have web application in ASP.NET 2.0 and C#.I have a gridview and i have a checkbox in the gridview. I am trying to save the checked record from the gridview to the database. The time taken to save the data is becoming huge and causing performance issues.
[Code]...
View 8 Replies
Feb 16, 2011
how to improve the performance of dynamically load user control
View 1 Replies
May 1, 2010
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?
View 6 Replies
Mar 8, 2010
I have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?
View 6 Replies
Oct 4, 2010
i am using data gridview asp.net control and i bind it dynamically, gird displayed 80,000 thousands records so i am using paging techniques,on each page gird display 10 record so when i am change page each time gird should filled 80.000 thousands records so how could i bind gird from pageIndex,pageSize rather than bind it whole records
Code]....
it works properly but when i change page or grdTender_PageIndexChanging event fire each time gird fill with 80.000 records now i want to bind it from current pageIndex to current page size to improve the performance of datagird
View 5 Replies
Mar 26, 2010
I have an SP in backend that retreives multiple recordset/DataTable where each recordset/Datatable contains 10 records and 8 columns.
The Count of recordset/Datatable differs based on parameters.
The SP retreives Data in nearly 0.01 seconds.
I have been displaying the records by looping each Datatable and each record in DataGrid Template Control, this way the page loads very slowly.
Can some one please suggest me on how to display/Load the data more efficiently and faster in front end ASP.NET 2.0?
Can I perform some Multithreading to display records from different datatables?
View 2 Replies
Jul 29, 2010
In ASP.net when we perform paging over Gridview or DetailsView than the Gridview fetch all rows from the Database each time.
Suppose our Database contains 100 rows and we have configured Paging in Gridview with page size of 10 records per page.But whenever we click on the the pager control of gridview for any particular page no. then GridView should fetch only particular 10 rows from database.
If we click on page no 3 then it should query only rows 21-30 but it fetches all rows and neglect the remaining .which is simply a wastage of resources.
View 3 Replies
Aug 11, 2010
In ASP.net when we perform paging over Gridview or DetailsView than the Gridview fetch all rows from the Database each time.Suppose our Database contains 100 rows and we have configured Paging in Gridview with page size of 10 records per page.But whenever we click on the the pager control of gridview for any particular page no. then GridView should fetch only particular 10 row
View 3 Replies
Sep 20, 2010
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?
View 1 Replies
Apr 29, 2010
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.
View 1 Replies
Mar 20, 2011
I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 Replies
