score:1
"linq" includes linq to objects, linq to sql, etc. you can certainly query in memory, but maybe you should wait until you've done a performance analysis before optimizing. you may optimize the wrong thing.
score:1
ad hoc, loading up to 250 megabytes of data into client memory seems not to be such an good idea. if you have it memory, you can use linq to object and save the database roundtrips.
the problem is that your data is hierarchical and you have to fetch one row, examin it, and retrieve the releated rows and this causes so many roundtrips.
you could use lazy loading to retrieve more and more rows into client memory during the runtime of your program and perform more and more queries in memory when the working set stabilizes. but this will only help if rows are accessed multiple times and not only once or twice.
another solution might be to create recursive views or stored procedure using common table expression that retrieve releate rows up to some distance from a given row.
Source: stackoverflow.com
Related Query
- Can you use LINQ with in memory objects rather than SQL Server queries to improve performance?
- Can I use C# string interpolation with Linq to SQL
- How can you use LINQ to find Azure AD users with specific licenses using the Azure AD Graph API Client Library 2.0
- How can you use LINQ to cast from a collection of base class objects to a filtered list of their respective subclasses?
- How can I issue a LINQ query to a SQL Server to check if a column value starts with a word?
- Accessing SQL Server time in code with LINQ
- How I can write something similar to Linq .Any() when writing sql server queries
- How can you use Linq result with RDLC report?
- Storing binary objects in SQL Server with LINQ
- How can I use two different databases with Linq to SQL in Linqpad?
- Can I reasonably go five levels deep with a .Include in LINQ and a SQL Server 2012 Backend?
- How can I use Aggregate Operators in Linq queries with multiple tables?
- What can I do to resolve a "Row not found or changed" Exception in LINQ to SQL on a SQL Server Compact Edition Database?
- Instantiate empty IQueryable for use with Linq to sql
- How can you handle an IN sub-query with LINQ to SQL?
- Can you use LINQ types and extension methods in IronPython?
- How do you use LINQ with Sqlite
- Odd behavior in LINQ to SQL with anonymous objects and constant columns
- Can I capture a local variable into a LINQ Expression as a constant rather than a closure reference?
- How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
- How can you do custom sorting in LINQ with null always on the end?
- Can you reverse order a string in one line with LINQ or a LAMBDA expression
- How to use distinct with group by in Linq to SQL
- How can I directly execute SQL queries in linq
- How can I use Linq with a MySql database on Mono?
- LINQ to SQL - Why can't you use a WHERE after an ORDER BY?
- How can you update a Linq Expression with additional parameters?
- Can I use LINQ to check if objects in a list have a unique ID?
- Can I use a collection initializer with LINQ to return a fully populated collection?
- How can you see the sql that is causing an error on SubmitChanges in LINQ to SQL?
More Query from same tag
- How to group by a new string in LINQ
- values to dictionary c# .net
- Copying data from var to DataTable after LINQ query
- How to select records with duplicate column by group using LINQ?
- Compute cosine and sine with Linq
- I need to create an xml file, from a csv file that doesnt save the first row as tags
- When are collections enumerated (IEnumerable)
- Getting Column Value from another Subquery
- .OrderBy() / .OrderByDescending() with .FirstOrDefault()/.First()
- Can't "Enable Editing" on my gridview
- Is it possible to return IEnumerable of anonymous objects from DataContext.ExecuteQuery?
- How to shape the results returned by dynamic join
- c# can I type the code I want to execute in LINQ expressions
- Update Rows in the database with LINQ
- Using LINQ, how to convert a IList<IList<object>> to IList<object>?
- SQL Selecting from 3 tables returns syntax error
- Remove rows with same column value from DataTable and add corresponding values
- LINQ converting anaonymous list to strongly type with date splits in groupBY
- ASP.NET Core Returning
- How can I convert EnumerableRowCollection<string[]> to a regular string array?
- Is there any benefit to using LINQ to get the first (and only) element in IEnumerable<T>?
- LINQ to XML - list of custom objects with attributes from parent
- Issue displaying LINQ query results in a grid in C#
- Bind multiple dropdowns from a single list
- c# how to check if query result is empty as opposed to null
- Different Ways to Pull Number From Results View Of LINQ Query
- How do you write a query that returns an ordered list starting from a specific item?
- LINQ join lambda syntax - need to translate this from query
- LINQPad - can't understand the query generated
- Need help Linq query join + count + group by