Second-Level cache without transactions?

[StuS]

I've read that we can't use 2nd level caching until we use (explicit) transactions - however, we are using a an Informix system - which for reasons currently beyond our control; an accounting system -  we cannot use transactions until we move to SQL server.

Second level caching could greatly improve our performance by cache data that doesn't changed often - is there any way at all to use it with implicit transactions?

[Ramon Smits]

Is the caching done to improve performance of for business logic or done to speed up data passthrough to a front-end? If it is the last scenario then you are probably better of with a caching solution that does its job way earlier then at the point where the data would be retrieved from the database. For example, output caching.

[StuS]

It will initially be done to speed up business logic, and data available to that logic

On Thursday, April 19, 2012 2:04:32 PM UTC+1, Ramon Smits wrote:

Is the caching done to improve performance of for business logic or done to speed up data passthrough to a front-end? If it is the last scenario then you are probably better of with a caching solution that does its job way earlier then at the point where the data would be retrieved from the database. For example, output caching.