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: 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. =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
