Kerry Moorman
9/20/2007 2:00:00 PM
zperetz,
I'm confused. Is your performance issue interacting with SQL Server? Or is
your performance issue filtering data in a datatable?
Perhaps you could also say exactly what your application is trying to
accomplish?
Kerry Moorman
"zperetz" wrote:
>
>
> "Kerry Moorman" wrote:
>
> > DZP,
> >
> > Actually, I think it is a lot of data.
>
> OK, so we now spleet the data tables into smaler data tables each of 30K
> Yet no improvement
> Now trying on less then 10k
> steal nothing
> server response with no data loockup is 1/1.5 Sec long
>
>
> >
> > Remember that datasets, datatables, etc are not meant to be used as an
> > in-memory database. You should let your database engine filter the data and
> > return just the data you need.
> >
> > Kerry Moorman
> >
> >
> > "zperetz" wrote:
> >
> > > Hallo to all
> > > I'm on dot net framework 1.1
> > > I have a data table populated with about 300k records
> > > I have a serious performance issue filtering the data table using data table
> > > select methode
> > > (I can not use find on the rows collection because I search for non PK values)
> > > there should be a way to improuve performance, Since its not so much data
> > >
> > > Thanks ahhead
> > > DZP
> > >