Our development DB server is an old workstation because that's basically what the client has.
Message from Adam Sills <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received on 10/10/2005 01:48 PM 10/10/2005 01:48 PM Adam Sills <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM Please respond to "Unmoderated discussion of advanced .NET topics." <[email protected]> Sent by "Unmoderated discussion of advanced .NET topics." <[email protected]> To: [email protected] cc: Subject: Re: [ADVANCED-DOTNET] DataRelation Two things: 1 - use Reflector. It apparently does use an Index object (based on the keys of your DataRelation), does a search through the array to find the min and max index and returns the results between said min/max. 2 - 31K rows in 3.5 seconds? Sounds like your database needs some serious tuning work. Adam.. > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Franklin Gray > Sent: Monday, October 10, 2005 1:33 PM > To: [email protected] > 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. =================================== 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
