Q&A BY TAG 'Cache'

You must sign in to ask a question. If you do not have an account, you can register here

Error on Cache mode enable for Partial or Full on base view
answered 21-07-2015 19:04:11 -0400

In trying to activate the cache for a base view which was created from a query, it throws up an error dialog in either trying to activate partial or full cache on the base view. Error for partial cache activation is: "error modifying view: An SQL data...

Answers: 1

cache

Derby Cache Exception in Log and no Cache results returning
answered 21-07-2015 08:46:26 -0400

Created a base view which has custom sql to create it that comes back with two text columns. Both vase view and original database have those columns set as varchar(1024). When executing the base view with cache invalidate it returns rows back. When ...

Answers: 2

cache derby

Full cache, changing settings, redeploying VQL code seems to cause the existing cache to be invalidated?
answered 18-06-2015 14:07:28 -0400

I have a view, 'person_cache', that is configured to have a "Full" cache and a TTL of 86400 (1 day). I have a batch job that invalidates the existing cache and loads it once every hour. I wanted to change the TTL to two weeks ( 1209600 ) and change m...

Answers: 2

cache

Join to a cached view twice, but only fetch once
answered 04-12-2014 14:04:24 -0500

I have view emp (jdbc) and view ad (LDAP). AD is a partially cached view. We join emp.id to ad.id and it works great. Now I need to also join emp.supervisor_id to ad.id to get the supervisor information. When I look at the execution trace, it app...

Answers: 2

cache VDP