Up to Discussions in Ask-the-Expert

This Question is Assumed Answered

1 "correct" answer available (5 pts) 15 "helpful" answers available (3 pts)
2 Replies Last post: Apr 29, 2008 5:30 AM by URPradhan

How to Cache Database on OCC ?

Apr 29, 2008 2:40 AM

Click to view RajivGu's profile Level 6 RajivGu 81 posts since
Apr 2, 2008

Hi,

I want to install occ application which runs on client machine,Is there anyway which ensure that the Database will be cached to client machine? So, next time when I connect to application instead of going to query database server it should fetch the information from cached record or database.

Thanks

Rajiv

Click to view friedger's profile MVP friedger 108 posts since
Jan 13, 2008
1. Re: How to Cache Database on OCC ? Apr 29, 2008 4:00 AM

Do you want to cache the whole data base? Or just one or two RecordSets?

I think it is about copying data between RecordSets one ConnectedRecordSet and one local e.g. SQLConnectedRecordSet from CDK. Then there is the question how to synchronize both. I am not sure whether there exists already publicly available implementations of strategies.

Friedger

Click to view URPradhan's profile Level 7 URPradhan 141 posts since
Mar 6, 2008
2. Re: How to Cache Database on OCC ? Apr 29, 2008 5:30 AM
in response to: friedger
He might be referring to disconnected dataset available in .NET, where initially you pull down the data from the database and stored in memory (IMDB). Then work with the in-memory data and finally submit the changes to the database server. Like as Curl claims "Communication with server when there is a need for updated data", ie, occasionally connected clients (OCC).

So he might be interested in; how/where to keep the table data at client side and how to update again with server.

Am i right rajivgu ?

Actions

More Like This