Hi,
I have a requirement for caching large amount of data like 1-1.5 GB per user. The data is not static but its a transaction data which changes intermittently if not frequently. Front End is .NET based windows form and connects to backend oracle database through app. server where singleton remoting application is running. Fetching the data directly from oracle database takes app. 25-30 second for single record because one record may contain 50K detail record.
We tried to implement it using Caching Application Block at the client side but due to the memory constraint of 2 GB in 32-bit system, application gives 'Out of memory' exception. We cannot go for SQL express at the client side and SQL Standard edition at the server to cache the data in database due to organization constraint.
Now, we have implemented multiple copy of the windo ...
Go to the complete details ...