dataset in a class performance question

pete.mcnamee

Performance-wise: i have a class in my app. that holds a dataset and functions to access the dataset and obtain different data is it better: 1) to have the dataset recreated each time a class is called to access a method on the data -or- 2) to somehow have the class remain in memory throughout program execution. if 2), then what would be the procedure for making the class stay instantiated in memory? thanks in advance Pete McNamee [email protected]

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

pete.mcnamee23y ago
sorry, WINforms
+1
pete.mcnamee23y ago
webforms. the dataset is not that large. i am trying to avoid making too many calls to the database when a batch update will do. i'm basically holding four tables in the dataset, none of which are that large. the application is similar to quicken or microsoft money so there would be multiple calls to the db whenever new transactions were made or updated, etc. i feel that limiting network activity is more efficient at this point, but at what point (size of dataset) do you think it is appropriate to switch over? thanks for your help. Pete McNamee
+1
sacresp23y ago
WinForms or WebForms application? Generally, software design is finding a balance between memory usage and raw performance. You have to think how much memory you have to spend.
+1