Do you really care about the underlying implementation? It sounds like you've got a bead on the actual performance of the 2 candidate methods--isn't that your bottom line?
-----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Franklin Gray Sent: Monday, October 10, 2005 11:33 AM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] DataRelation If I load 3 datatables into a strong typed dataset with relations and have the strong-typed dataset bound to a grid with lookups, it runs in 3.47 seconds. If I do the join in sql and bring back one datatable and have the grid bound directly to the strong typed dataset, it takes 3.35 seconds. This is with 31,000+ rows of data in the main table. I find it hard to believe it's doing table scans. Message from Adam Sills <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received on 10/10/2005 01:02 PM 10/10/2005 01:02 PM Adam Sills <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM Please respond to "Unmoderated discussion of advanced .NET topics." <ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> Sent by "Unmoderated discussion of advanced .NET topics." <ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM cc: Subject: Re: [ADVANCED-DOTNET] DataRelation I think the suitable answer is simply: Don't assume a DataTable/DataSet truly has database semantics and behavior. It may look like a database or smell like a database, but it most certainly is not a database. There are no indexes on DataTables so everything is a "table scan" (though again, it's not a database so it's an array scan). And using Reflector will confirm this in a few minutes of digging through the decompiled code. Adam.. > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Pardee, Roy > Sent: Monday, October 10, 2005 12:55 PM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] DataRelation > > Oy, such bullying. Can't we all just get along? > > I thought Franklin's question was reasonable... > > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Vince > Pacella > Sent: Monday, October 10, 2005 10:45 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] DataRelation > > Oh my, an exclamation point. Please control your emotions. > > Regards, > J. Vince Pacella / OOCL Chicago > Cell 773-454-8683 Fax - 773-867-5050 > > Cargo Tracking Online at: > www.cargosmart.com > > > > > -----Original Message----- > > From: Unmoderated discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of Franklin > > Gray > > Sent: Monday, October 10, 2005 9:57 > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > Subject: Re: [ADVANCED-DOTNET] DataRelation > > > > If you don't have anything helpful to say then just shut up! > > We don't need your judgements. > > > > > > > > > > Message from Ted Neward <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM > > received on > > 10/09/2005 08:09 PM > > > > 10/09/2005 08:09 PM > > > > > > > > Ted Neward <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM > > > > Please respond to "Unmoderated discussion of advanced .NET topics." > > <ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> > > Sent by "Unmoderated discussion of advanced .NET topics." > > <ADVANCED-DOTNET@DISCUSS.DEVELOP.COM> > > > > > > > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > cc: > > Subject: Re: [ADVANCED-DOTNET] DataRelation > > > > Don't you think you should find out the answer to that > question before > > > you start giving advice? > > > > Ted Neward > > Author, Presenter, Consultant > > Java, .NET, XML services > > http://blogs.tedneward.com > > > -----Original Message----- > > > From: Unmoderated discussion of advanced .NET topics. > > [mailto:ADVANCED- > > > [EMAIL PROTECTED] On Behalf Of Franklin Gray > > > Sent: Wednesday, October 05, 2005 12:22 PM > > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > > Subject: [ADVANCED-DOTNET] DataRelation > > > > > > Anybody know how the linking is done? Does ADO.Net use a > > hast table or > > > some other kind of indexing or is it a table scan (I'm > sure it's not > > > > this)? I'm trying to convince my boss that he shouldn't do > > joins on the > > > DB side if he already has the Lookup table in a datatable > > on the client > > > side. > > > > > > =================================== > > > This list is hosted by DevelopMentor. http://www.develop.com > > > > > > View archives and manage your subscription(s) at > > > http://discuss.develop.com > > > > =================================== > > This list is hosted by DevelopMentor(r) http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > > > > > =================================== > > This list is hosted by DevelopMentor(r) http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > > > > > > IMPORTANT NOTICE > Email from OOCL is confidential and may be legally privileged. If it > is not intended for you, please delete it immediately unread. The > internet cannot guarantee that this communication is free of viruses, > interception or interference and anyone who communicates with us by > email is taken to accept the risks in so doing. Without limitation, > OOCL and its affiliates accept no liability whatsoever and howsoever > arising in connection with the use of this email. > Under no circumstances shall this email constitute a binding agreement > to carry or for provision of carriage services by OOCL, which is > subject to the availability of carrier's equipment and vessels and the > terms and conditions of OOCL's standard bill of lading which is also > available at http://www.oocl.com. > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor. http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
