Performance Problems with filtering in Dataview

  • Thread starter Thread starter Robert Gregory via DotNetMonster.com
  • Start date Start date
R

Robert Gregory via 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
 
Are you caching the DataView or the DataTable the view accesses?

---

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

***************************
Think Outside the Box!
***************************
 
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.
 
Back
Top