StrataFrame Forum » StrataFrame Application Framework - V1 » WebForms (How do I?) » Shared DataTable in web environment

Shared DataTable in web environment

ChanKK — Wed, 29 Apr 2009 10:48:07 GMT

Hi,
I would like to use shared data table so that every session shared the same data. May I know any thing I need to taken into consideration while using it?

Thank you

RE: Shared DataTable in web environment

Trent L. Taylor — Wed, 29 Apr 2009 10:48:07 GMT

Well, this is not a simple question as there are a lot of ways to handle this. First of all, you can set timeouts at the IIS level in regards to the application pool being recycled. So this is when you may want to cache the BOs to a database so that they can be retrieved in their state prior to being disposed. This is not something that I can give you a straight answer on without first setting something like this up and playing with it a while. But I know that you could tackle this several different ways.

This is why I was mentioning the serialization so if you had the need to save off the state and then restore a state between sessions.

RE: Shared DataTable in web environment

ChanKK — Wed, 29 Apr 2009 10:44:52 GMT

Hi,
Thank you for your explanation.
How could I manage its "expiration period"? I would like to cache active employee list which might contains > 10,000 records. I can cache it using static variable and so, but everyday also might have new join and resign employee. Therefore, I need to refresh it intervally. That is the reason I looking for caching mechanism.

Please advice. Thank you

RE: Shared DataTable in web environment

Trent L. Taylor — Wed, 29 Apr 2009 09:04:07 GMT

You can you create one of these yourself quite easily. As you may already be aware, the BO has the ability to serialize and deserialize out-of-the-box. So if you want to save these sesssions off to disk you can. Now if you are just going to hold these in memory then this is not necessary. In any case, you can create a Dictionary of keys and BOs that are static at the application session level so that they are shared across all sessions. So in the global.asax I would instantiate my dictionary and when a reference is made and a key does not exist, then add one to the cache. You could also load all of them up at the beginning as well. But to do this, just create a static dictionary that is stored off as an application variable and then manipulate the cache as needed during the life of the object.

RE: Shared DataTable in web environment

ChanKK — Tue, 28 Apr 2009 11:22:35 GMT

Hi,
Thank you.
If I would like implement cache to these "common" Business Object data, any recommended caching tool/framework?

Thank you

RE: Shared DataTable in web environment

Trent L. Taylor — Mon, 27 Apr 2009 07:48:43 GMT

In a web environment you are better off create an application BO versus creating a shared data table. This would be due to primarily the session states. But if you are wanting to share a BO across all user sessions, then create an application level BO instance versus a shared data table.