jwite2003
04-14-2003, 01:23 AM
Hi...
I'm torn between using one big dataset in the global.aspx file & using lots of smaller ones in the individual webforms.
If I did the one big one in global.aspx I would probably end up passing datatable objects or datarow objects to the individual webforms as the information is requested. I liked this idea because it only seems to take one read from the database to fill the dataset. With small datasets in webforms I would be rereading the information in everytime the webform is displayed.
On the flip side saving a huge dataset object as a global session variable is probably going to take up a good chunk of server memory for each user.
Anyone know if one of these approaches is generally recommended over the other? Or is it just a preference of speed vs memory usage?
Thanks,
I'm torn between using one big dataset in the global.aspx file & using lots of smaller ones in the individual webforms.
If I did the one big one in global.aspx I would probably end up passing datatable objects or datarow objects to the individual webforms as the information is requested. I liked this idea because it only seems to take one read from the database to fill the dataset. With small datasets in webforms I would be rereading the information in everytime the webform is displayed.
On the flip side saving a huge dataset object as a global session variable is probably going to take up a good chunk of server memory for each user.
Anyone know if one of these approaches is generally recommended over the other? Or is it just a preference of speed vs memory usage?
Thanks,