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]...
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
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 RepliesI 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 RepliesI 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?
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]....
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
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 RepliesMy 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?
regarding the performance improvement in Asp.Net?The best practise tips for asp.net performance improvement?
View 4 RepliesI see bugs? give me your opinion really improve my site es [URL] this is metasearch fly meta search flights
View 2 RepliesI 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 RepliesI 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 RepliesI 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 Replieshow to improve the application performance while writing LINQ Queries ?Like the optimization techniques.
View 2 RepliesI 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.
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?
how to improve the performance of dynamically load user control
View 1 RepliesI 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 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 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 RepliesI have got a table in SQL Severs as following, which contains sales data (approx 10m records), the indexes and primary keys are SalesDate, StoreNo and ItemNoSalesDate StoreNo ItemNo SalesQtyWhen I am querying the table for a given item and store's sales for the last 7 days, if I use the query:
[Code]....
The query runs almost instantly, obviously using IN is the faster mehtod here, but I have read elsewhere that using BETWEEN is the quicker method, can anyone confirm?
i am calling a scalar function from a stored procedure. Does using user defined scalar finction has a negative impact on performance.
View 1 RepliesI use the code in [URL] to execute DTS in ASP.NET as following
[Code]....
but it always fire the OnQueryCancel event, I don't know why
I used the main code for firing the DTS , it check the hlobal variable and when reach the line
package.Execute(); it fire OnQueryCancel event ;
I tried alot of techniques but all of them failed
I have created the stored procedure in SQL server 2005. i have used nested cusrsors in this SP. also many records are there. So, its performance is too low.
i forced to use cursor, because the this is calcualtion process. i have to fetch the records one by one, do the calculation and insert the result to the another relevent tables.
So it cause big performance issue.this is my sample scanario.
First i have to take the products from the customerforecast for the certain duration. (i used cursor to fetch the products)
then i need to get the list of machines can run for the each product. (i used cursor to fetch the machines)
then i have to fetch the Unit per hour value for the combination of machine and prduct.then i have to use formula and do the calculation and store the result to the 3 different tables.
