performance issue filtering data table...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
DZP,

Actually, I think it is a lot of data.

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
 
Kerry Moorman said:
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
 
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
 
Hallo, ;)
Ah, the 2.0 Framework addresses many of the performance issues you're
seeing with 1.1, but it cannot help with a challenged design. Yes, how about
telling us what you're trying to accomplish? What's the program supposed to
do?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
I never heard of anyone, until now, pulling 300K into a DataTable in a web
app.
I think this is wrong even in a WinApp. I know one developer pulling 240k
rows into a WinApp that got fired.
Paging, Filtering etc... is needed. The design is suspect at best.
 
Back
Top