Performance Problems with filtering in Dataview

Hi all!
I would really appreciate getting some help on the following problem:
I use a cached dataview as a source for my datagrid. The user selects items
from controls and based on the selections a filter is applied on the
dataview and the datagrid re-databinded. Now the problem: when I test the
application on the server it works extremely fast, the filtering processes
within 2 to 3 seconds on a datatable with 4000 rows!
When I try to access the same site on the server from a client-Computer in
the business network the filtering takes about 40 to 60 seconds!!!

Does anyone have a clue how to explain these extreme performance
differences?

THANKS in advance,

Robert Gregory

--
Message posted via http://www.dotnetmonster.com

NoSpamMgbworld
Wed Mar 09 14:01:03 CST 2005

Are you caching the DataView or the DataTable the view accesses?

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"Robert Gregory via DotNetMonster.com" wrote:

> Hi all!
> I would really appreciate getting some help on the following problem:
> I use a cached dataview as a source for my datagrid. The user selects items
> from controls and based on the selections a filter is applied on the
> dataview and the datagrid re-databinded. Now the problem: when I test the
> application on the server it works extremely fast, the filtering processes
> within 2 to 3 seconds on a datatable with 4000 rows!
> When I try to access the same site on the server from a client-Computer in
> the business network the filtering takes about 40 to 60 seconds!!!
>
> Does anyone have a clue how to explain these extreme performance
> differences?
>
> THANKS in advance,
>
> Robert Gregory
>
> --
> Message posted via http://www.dotnetmonster.com
>

Val
Wed Mar 09 19:15:14 CST 2005

Hi,

I would say 2-3 seconds for 4000 is a pretty bad performance as well. It
should be much faster unless you have very old PC. Most likely there is
something wrong in a application design. Try to check if there are no some
additional event that fire when you filter dataview. If it fires multiple
times you could expect performance
issues.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Robert Gregory via DotNetMonster.com" <forum@DotNetMonster.com> wrote in
message news:37163639b6ce475b914a7127e9348de4@DotNetMonster.com...
> Hi all!
> I would really appreciate getting some help on the following problem:
> I use a cached dataview as a source for my datagrid. The user selects
> items
> from controls and based on the selections a filter is applied on the
> dataview and the datagrid re-databinded. Now the problem: when I test the
> application on the server it works extremely fast, the filtering processes
> within 2 to 3 seconds on a datatable with 4000 rows!
> When I try to access the same site on the server from a client-Computer in
> the business network the filtering takes about 40 to 60 seconds!!!
>
> Does anyone have a clue how to explain these extreme performance
> differences?
>
> THANKS in advance,
>
> Robert Gregory
>
> --
> Message posted via http://www.dotnetmonster.com