Re: Performace problem with DataView.RowFilter
From: W.G. Ryan eMVP (WilliamRyan_at_NoSpam.gmail.com)
Date: 01/16/05
- Next message: Richard Blewett [DevelopMentor]: "Re: constructor"
- Previous message: Joe: "Re: Performace problem with DataView.RowFilter"
- In reply to: Joe: "Performace problem with DataView.RowFilter"
- Next in thread: Sahil Malik: "Re: Performace problem with DataView.RowFilter"
- Reply: Sahil Malik: "Re: Performace problem with DataView.RowFilter"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 16 Jan 2005 17:49:42 -0500
Joe - Sahil is dead right on this (as always) - I had reset the filters a
while ago on 2,000+ rows - then redid it using GetChildRows - it went from
taking around 12 seconds to complete to less than one. Night and day there.
--
W.G. Ryan MVP (Windows Embedded)
TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Joe" <J_no_spam@_no_spam_Fishinbrain.com> wrote in message
news:#qca2VA$EHA.3840@tk2msftngp13.phx.gbl...
>
> Not sure what group this question is better suited for so I sent it to
both.
>
> I have a DataTable which contains 1545 rows. I have a method that returns
a
> DataTable of distinct rows based on one column. This table ends up with
386
> rows.
>
> I need to loop through the smaller table and filter a DataView based on
each
> row from this table.
> This loops takes ~5 secs. Is there anyway to improve this?
>
> DataTable dt = SelectDistinctValues(...); // returns a table with 386 rows
> foreach (DataRow dr in dt.Rows)
> {
>
> dv.RowFilter = string.Format("value = '{0}'", dr[0].ToString() );
>
> foreach (DataRowView drv in dv)
> {
> ...
> }
> }
>
>
- Next message: Richard Blewett [DevelopMentor]: "Re: constructor"
- Previous message: Joe: "Re: Performace problem with DataView.RowFilter"
- In reply to: Joe: "Performace problem with DataView.RowFilter"
- Next in thread: Sahil Malik: "Re: Performace problem with DataView.RowFilter"
- Reply: Sahil Malik: "Re: Performace problem with DataView.RowFilter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
