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® 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
