Will indexing a SQL table improve the performance of a LINQ statement?
Apologies for what may very well be a stupid question.
I'm just intrigued as to (a) will indexing improve performance (b) how will it improve performance and (c) why will it improve performance?
Also, if this does improve performance, would this be the case across the board for LINQ to SQL, LINQ to Entities, LINQ to Objects, etc, etc.
Again, if this is a really stupid question, I do apologise.
I have 200,000 records in a database with the PK as a varchar(50) Every 5 minutes I do a SELECT COUNT(*) FROM TABLE If that result is greater than the List.Count I then execute SELECT * FROM TABLE WH
I'm using hibernate search and lucene index in infinispan. But the time for indexing is too long. I'm trying to optimize the performance of indexing with tuning options. I.e, set hibernate.search.[d
i have this sql statement : Select FileURL from story where ActivityID = ' listACt ' ; How do i convert this to linq lambda? i have this but its not working : public IList<Model.story> Get
I have a statement similar to this that I need to run in Linq. I started down the road of using .Contains, and can get the first tier to work, but cannot seem to grasp what I need to do to get additio
How do i increase the performance of below linq query? While running it, it threw an error of System.OutOfMemoryException. Note: I have a lot of records in XrmContext.sun_POSSet entity var a = (from t
Im having 260 columns table in SQL server. When we run Select count(*) from table it is taking almost 5-6 to get the count. Table contains close 90-100 million records with 260 columns where more th
below query takes more than 1 minute, how to improve the performance. full scan is happening in both the tables. how to avoid? query plan: SELECT STATEMENT ALL_ROWSCost: 62 Bytes: 14,355 Cardinality:
Succinct How do I performance tune my Linq To SQL DAL methods? Specifically the amount of data being transferred. Verbose I have a Winform app that uses Linq To Sql to access it's data. We have 5 bran
I am deprecating a project from linq coding back to sql stored procedures. (My company refuses to upgrade our sql 2000 database.) I am stuck on this current code trying to convert it to sql. Can anyon
Update Apparently, jQuery templates can be compiled and it helps performance for templates with if statements shown here. But as shown here, the precompiled jQuery templates doesn't do much for my cas
Hello i using LinQ to sql Link i need to gel list of items that have ParentID==X server code ul_LeftMenu.DataSource = data.TABLE_MENU_ITEMs.ToList(); ul_LeftMenu.DataBind(); i need some think like t
I have summarized my problem in following code. NorthwindDataContext dc = new NorthwindDataContext(); var query = from c in dc.Customers select c; Above code is generating following sql statement SE
Is there any reason use standart HTML controls (input type=text,input type=checkbox) instead of asp.net controls ( asp:TextBox, asp:CheckBox) to improve performance?
I want to create a web application using ASP.NET. Which method should I use, LINQ or SQL query? Which gives the best performance? Please help me.
How I can get sql table name in linq For example : In linq my table object name is : TblUserDetail. But this table name in sql is TblUserDetails.
I am seeking for advice, how I can improve this in terms of speed: My Data-model: class Events(ndb.Model): eventid = ndb.StringProperty(required=True) participants = ndb.StringProperty(repeated=True)
Please help me out with this big data problem. I have a very large table (500G) that stores cookie information collected from one website, and I try to provide service to many other clients. For each
I have a bit complex linq2sql query, it doesn't contain any 'order by' statements, but somehow linq2sql thinks it is necessery and inserts it. Unfortunately this 'order by' statement hurts performance
Does anybody know how to improve performance of this query? I'm using doctrine DQL model, here's the code (it takes 5-6 sec without pagination bundle) Controller: $data = $this->getDoctrine() -&
In SQL I can use the IN operator: select * from project where id IN (select f.id_project from funds) How can I convert this statement to LINQ? Controller.Project.Where(p => p.id == id_funds); // I
i was asked by an interviewer regarding sql server. the scenario was we have table with million or records. table has primary key, clustered and non clustered keys as well. still the data is fetching
how to use table hints in Linq to sql when call submit changes method dataContext.table2.something = dataContext.table1.something; dataContext.SubmitChanges(); i want to use it like this sql code: de
Is it possible to do common table expressions (CTE) (like shown below) in Linq to SQL. I'm pretty new to CTE's as well as Linq to SQL. I'm currently Stored Proc free (but not against them by any means
I am trying to improve query readability by using a function in SQL Server Express 2008. Here is a sample of what I'm trying to do. I have a table where we store a max temperatures reading per hour of
i have this piece of code that selects all users from the table and another sql statement that counts the number of records for every user. the problem I'm facing is that i have a sql in a foreach loo
I am trying to write a linq to sql statement that will join a total of 3 tables. table 1 = users (userId) tabe 2 = userCourses (userId, CourseId), table 3 = courses(courseId). This is what i am tryin
I have this Informix SQL statement which takes ages to run. Does anybody see any way to optimize it so it wouldn't take so long? SELECT * FROM OriginalTable WHERE type = 'S' AND flag <> 'S' INTO
I have the following sql which takes a long time to execute, are there any better way of writing this to improve speed. Any help is highly appreciable. Thanks SELECT a.KeyField FROM Details a, Master
What is the most common and easy to implement solution to improve speed for SQL Server 2008R2 database & .Net 3.5 application. We have an application with the following attributes: - small number
Excuse my pseudo code below. I'm pretty sure there is a magical way to write this in a single linq statement that will also dramatically improve the performance. Here I have a list of millions of reco
Is there any way to convert following SQL statement into LINQ? select ve.EntityID , fin1.FinanceStat as FinanceStat_New , fin2.FinanceStat as FinanceStat_Old from ValuationEvents_PIT_New as ve left jo
we have an online shop with about 8000 products. Now its time to improve the performance of product listing / filtering. Currently we store the results of previous searches / listings temporary in the
How to get an array of data columns via LINQ To SQL? I'm looking for something like this : DataColumn dc = DataContext.Table.Columns;
string id = (from c in context.Users where c.u_id == Id select c.u_id).SingleOrDefault(); 1)How i can improve the performance for the above using Linq complied query for the above. We are limited to
Using the StackExchange.Profiling.MiniProfiler class to profile an ASP.NET MVC application with Linq-To-Sql as ORM. I'm trying to reduce one action to one SQL, so that I don't have any duplicates anym
In our Oracle datbase we have a table called RULES, with a field called SQLQUERY. This field is a varchar with an SQL statement stored. The PK is DM_PROJECT. A typical statement that is stored could b
I want to write linq statement for this sql statement below: select * from Table1 where Table1.Id in (1, 2, 3, 4) I have selection set in a array or list What is the linq statement?
I learn methods of improve performance a code. For study that I wrote function wich return basic descriptive statistic like a psych::describe. I've tried different versions of the loops and at the mom
We have been developing a DB web app which constantly queries an SQL store of objects (about 80,000 of them) which are related to each other in a hierarchy. (i.e. many objects have parentid which rela
I am using jquery mobile 1.3.2 for my Phonegap Build app. I would like to improve the performance of the slider input : because when you try to slide it on a phone, it is very slow, as I do a lot of U
I saw some code were linq was used on a traversing a dictionary object in c#. I thought linq was just for linq to sql for databases. The linq used in the code mentioned was a select type statement, ju
Please help me optimize this linq statement for performance. There are about 4000 drivers to go through and the page times out. I am rather new to Linq tblDriver driver = Mapper.Map<Domain.Driver,
In SQL I would normally type this out, hard to read - yes, but it does work (IIF(Table1.Field1 = 1, -- Field1 is True IIF(Table2.Field2= 1, (SUM(Table1.Field3+Table1.Field4)),(SUM(Table1.Field3+Table1
i am quite new to linq and i am having some difficulties writing this query efficiently in LINQ. SELECT ID, UniqueID, RouteHeaderID, RouteObjectState, OriginalRouteUniqueID FROM dbo.MeterReadingOrderE
How does indexing work in SQL and what benefits does it provide? What reason would there be for not indexing? And what is the difference between indexing a single column vs. indexing multiple columns?
It seems to be really hard to improve the performance of a UIWebView, especially for websites like Mashable or Ars Technica, where tons of scripts are loaded and long, multi-page articles are common.
CREATE TABLE PersonTask ( PersonId INT NOT NULL, WeekId INT NOT NULL, WeekDaysTaskId INT, WeekEndTaskId INT ) GO CREATE TABLE Task ( Id INT PRIMARY KEY, [Description] VARCHAR(250) NOT NULL ) GO INSERT
I have a table with millions of rows where one of the columns is a TIMESTAMP and against which I frequently select for date ranges. Would it improve performance any to index that column, or would that
Can I join the following 3 statement to display sick_total_day, other_total_day, other_total_day in one row (same where clause) ? SELECT staff_key, sum(days_applied) as sick_total_day from Tleave_sick
I have a sample database with 8 million users where the manage account page takes 8 seconds to render. It boils down to the method GetUserId calling Membership GetUser. The GetUser sql looks like this