473,387 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

LINQ PErformance Question

SC
Having inherited an NHibernate-based website, I'm not sold on OR/M mapping
tools for largest sites - from what I've seen, even "tuned" nhiberate
queries result in poor performance and I haven't seen them scale well - just
one person's experience.

Has anyone used the new Linq technology on a database contained hundred of
thousands / millions of rows - can you tune Linq to retrieve data from
tuned/optimized sql queries? Just trying to understand if the OR/M stuff
(which I agree does give the developers a benefit in producing results
faster) creates a beneficial production / performance trade-off for larger
databases, or does it truly shine only with relatively small datasets.

Thanks for any opinions that people using the stuff may wish to share!
Aug 2 '07 #1
2 1537
SC wrote:
Having inherited an NHibernate-based website, I'm not sold on OR/M mapping
tools for largest sites - from what I've seen, even "tuned" nhiberate
queries result in poor performance and I haven't seen them scale well - just
one person's experience.

Has anyone used the new Linq technology on a database contained hundred of
thousands / millions of rows - can you tune Linq to retrieve data from
tuned/optimized sql queries? Just trying to understand if the OR/M stuff
(which I agree does give the developers a benefit in producing results
faster) creates a beneficial production / performance trade-off for larger
databases, or does it truly shine only with relatively small datasets.

Thanks for any opinions that people using the stuff may wish to share!
I am curious as well. The LINQ demos that I've seen look like the old
DataGrid (or GridView) demos where you set a few properties and you got
paging, sorting, etc... Never mind that you are bringing back a million
rows every time.
Aug 2 '07 #2
Frank Rizzo <no**@none.netwrote:
I am curious as well. The LINQ demos that I've seen look like the old
DataGrid (or GridView) demos where you set a few properties and you got
paging, sorting, etc... Never mind that you are bringing back a million
rows every time.
Why would you be bringing back a million rows each time? The paging,
sorting etc is being done in the SQL, not in the .NET code. Without
that "magic" LINQ wouldn't be half as interesting as it is.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too
Aug 2 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: =?Utf-8?B?V2lsc29uIEMuSy4gTmc=?= | last post by:
Hi Experts, I am doing a prototype of providing data access (read, write & search) through Web Service. We observed that the data storing in SQL Server 2005, the memory size is always within...
7
by: =?Utf-8?B?Q2hha3JhdmFydGh5?= | last post by:
Today, after watching the presentation by Amanda Silver at http://channel9.msdn.com/Showpost.aspx?postid=335058 , from Channel 9, started exploring the LINQ features. Surprisingly, few facts...
2
by: =?Utf-8?B?VmFuZXNzYQ==?= | last post by:
I want to develop a datagridview allowing column selection and filtering, like this: http://www.codeproject.com/KB/grid/GridFilter.aspx This example is using dataset. My question is if: a) I...
22
by: paululvinius | last post by:
Hi! Testing som Linq-expressions and tried to measure performance and compare it to pre-Linq programming. The folloing two methods are functional equal but the non-Linq one is twice as fast....
0
by: John Smith | last post by:
Hello people, I have a performance query regarding LINQ that I would like some opinions. Currently we have a business logic framework that is used in n-tier applications. We read data from a...
2
by: AAAAA | last post by:
Hi guys I have a one question, is Linq to Sql good in pefornace? is better that traditional method? ismore than speed?? or is same? Thanks.. Regards Cesar
4
by: Jacek Jurkowski | last post by:
Why is it so slow? I really like that queries but using DataReader i have done my task's much more faster than ising LINQ...
5
by: =?Utf-8?B?cmF1bGF2aQ==?= | last post by:
linq on objects... want to find if the object exist in its collection if I have a loop searching in the collection foreach (myClass r in collections) { if (r.field01 == type && r.field02...
4
by: George | last post by:
I am a bit conservative type and usually give some time for technology to mature before starting to try it. Today my question is Linq. To start using it or not. So here is the voting questions....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.