D
djc
the aspnet_wp.exe process in taking up lots of memory. Right now just the
one main page loads and imediately goes to the top of the memory usage list
with around 32MB of memory usage. The page only contains 1 datagrid that IS
using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so that the
columns sort asc then desc on second click etc... As far as the data for the
datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.
1) any general ideas as to why so much memory is being used right off the
bat?
2) first page load is pretty slow. I know thats when it gets compiled and
the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20 seconds
to load on first time?
3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting my
object variables = Nothing but with .net I'm not sure which items need this
and the appropriate way to do it? .dispose? =nothing? both?
4) more ado.net specific but along the same lines as 3) above: when using a
dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I
need to explicitly close anything besides the connection object?
any info is appreciated. Thanks.
one main page loads and imediately goes to the top of the memory usage list
with around 32MB of memory usage. The page only contains 1 datagrid that IS
using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so that the
columns sort asc then desc on second click etc... As far as the data for the
datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.
1) any general ideas as to why so much memory is being used right off the
bat?
2) first page load is pretty slow. I know thats when it gets compiled and
the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20 seconds
to load on first time?
3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting my
object variables = Nothing but with .net I'm not sure which items need this
and the appropriate way to do it? .dispose? =nothing? both?
4) more ado.net specific but along the same lines as 3) above: when using a
dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I
need to explicitly close anything besides the connection object?
any info is appreciated. Thanks.