I am working on a small web site that does some recursive calculations on a relatively small set of data in a database. To increase performance and decrease load on the DB server, I would like to load the data into a DataSet that is made up of multiple DataTables. My problem is in knowing how to create this DataSet once and only once. I need to be able to access it from multiple web pages within the website and I would like to NOT have the DataSet recreated every time a new user accesses the web application, if possible. I'm working with C#, VS2010 and MySQL if it matters.
Anyone have suggestions on how I might approach this problem?
I wasn't quite sure which forum to place this in since it really involves web sites, C# and ADO. If it needs to go somewhere else, please let me know.
View Complete Post