How does the caching works?

Submitted by admin on Mon, 12/12/2011 - 18:10

Caching is configured by the following parameters in each Database’s properties page:

GreenSQL Pro caching process works in the following order:

Each response to a unique query is retrieved from the database and cached on the GreenSQL server for [Minimum cache time]
As long as Cache Time is not reached, responses to queries are retrieved from the cache
Once cache time is reached:
1. The cached response is flushed
2. Identification (MD5 signature) of the flushed response is stored and will be compared the next time the specific query will be used
3. The next time the specific query is called, the response will be retrieved from the database and an MD5 comparison is performed. If the response to the query differs from the previous response, cache time is reset to [Minimum cache time]; otherwise cache time grows gradually until it reaches [Max cache time]
When [Max cache time] is reached:
1. Cache time will be retained until MD5 comparison test finds a modification change in the Database content

Documents