Hello .net gurus,
Some quick backgroud on my asp.net app: I have a datagrid and a nested datagrid within it. I've built in paging, sorting, etc. The problem is the users would like to be able to print out the whole list. So i created a page that doesn't use any paging. This works great for pages with < 600 rows. Anything greater than this and the processing time grows exponentionally.
Currently i have 2 datatables. The first binds to the first datagrid, then the second datatable get's created into a dataview, then filtered based on the key of the first table. Now... when this second table has > 2000 records in it and i'm filtering on every single "ItemDataBound" the app can take upwards of 200 seconds to complete.
I ran a profiler on my application and i saw that 185 of those 200 seconds is all on the dataview.rowfilter command on my second dataview. I know this .rowfilter get's called 1 time for each row in the main table. I've already done some research and put a sort on the view on
the key i'm filtering on. And tried some other things which don't seem to help any.
What are some things i can do to make the rowfilter go faster? Should i be using a datatable("table").select() instead? Should i take a completely different approach? How can i make this more efficient?
Thanks for all the help!
Paul
Some quick backgroud on my asp.net app: I have a datagrid and a nested datagrid within it. I've built in paging, sorting, etc. The problem is the users would like to be able to print out the whole list. So i created a page that doesn't use any paging. This works great for pages with < 600 rows. Anything greater than this and the processing time grows exponentionally.
Currently i have 2 datatables. The first binds to the first datagrid, then the second datatable get's created into a dataview, then filtered based on the key of the first table. Now... when this second table has > 2000 records in it and i'm filtering on every single "ItemDataBound" the app can take upwards of 200 seconds to complete.
I ran a profiler on my application and i saw that 185 of those 200 seconds is all on the dataview.rowfilter command on my second dataview. I know this .rowfilter get's called 1 time for each row in the main table. I've already done some research and put a sort on the view on
the key i'm filtering on. And tried some other things which don't seem to help any.
What are some things i can do to make the rowfilter go faster? Should i be using a datatable("table").select() instead? Should i take a completely different approach? How can i make this more efficient?
Thanks for all the help!
Paul