DataSource Controls :: SQL Performance With IN Or BETWEEN?
Apr 17, 2010
I 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 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 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?
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?
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.
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.
I have a dataset that comprises of multiple tables (about 20) linked together with constraints to reflect the relational database. My question(s):
1) Will having multiple tables affect performance? I'm asking this as there are often times I would not need to get data for all the tables, but only for specific tables.
2) If it does affect performance, would breaking up the tables into their own datasets be the best solution. It seems to me that by doing that, you would lose the ability to apply constraints among tables and tables that might exist in multiple datasets will be subjected to replication.
I would like to have everything in one dataset as I get a view of the related tables and their relationships and also because the Fill method allow me to fill tables, maintaining the hierarchy of the data, but performance is still a key factor.
I have a query that I want to test the performance of when the query is included directly in the SqlDataSource versus when I call a stored procedure. Does anyone have suggestions on how I would be able to closely watch the actual steps here? I was thinking of turning on tracing and adding Trace.Write for each of the events that fire along the way. This doesn't seem efficient and I wanted to see if there was a better approach.
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 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.
i have a web application with master and content pages i just wanna know that can i use web user controls(.ascx) instead of these content pages and load them dynamically according to user clicks on the menu does using user control affects performance. i wanna load data from sql server in controls placed in web user controls so i m confused that it ll be a performance hit as i have to load the user control after every postback..plz give me suggestions on this. is there any performance testing tool that i can use to see the load on server.
Does anyone have performance comparision between asp.net and infragistics controls? Not only for complex controls. I need to compare all available controls.Note: The reason I am posting this here instead of infragistics is :)
The first and third view are simple now.The second view contains a user control AgreementDetailUC, which dynamically loads many other user controls onto several dynamically created tabs, as show below
When <Next> and <Previous> button is clicked, it take several seconds to show the second view. Page_Init is run very fast, it seems the time is spent on rendering the page.
My questions are:
1. How can the performance be improved?
2. How to change the cursor to hour glass when a button is clicked and change it back when the new view is shown (I can set it to hour glass when a button is clicked, but don't know how to set it back to normal).
I have been playing around with loading user controls in a CMS style where I can change the position and order. I have come up with this...
[Code]....
It all works fairly well - but I have alot of propertys in my user control code behinds where I could inject values into the usercontrol from my base class.
I like the way I can position usercontrols from the DB, I even added a time and date section where they could be switched on and off per day or time.
If I make every user control access the DAL for the data, it means i will have one select per user control, which means including my bassclass I could have upto 15 selects (visits tot he DB) to make the front page. Though this does not seem to make a performance problem, I was wondering if there was a better way of doing this.
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.....
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 just wondering if the DataPager is equal to the MySQL limit command, if I use the limit I get the number of rows I asked for. Is it the same with the DataPager? Or does it get the full query table and only then filter?
I tried to find out about subject but with no success. The point is that in the beginning I've made many user controls. My site is too slow. I have not idea yet if it is because of user controls.
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.
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
