LSCS Query caching in the runtime.

Hi

I notice when I analyze my queries that after the server gets a decent amount of hits and the CPU usage climbs the queries start to get sluggish. They go from about 120-140 ms to up to 2seconds at high CPU usage.

I'm looking into this itself with query optimizing / compacting etc but I was wondering, when I look at my reports in http://foo.bar.baz:1876/lscs/v1/util-command/idolpt/?action=grl&openlinks=on&refresh=0&sort=default&tail=500 that a lot of the queries are repeated even one right after another even though the queries are identical. Both could take up to 800 ms to execute... seems like a waste of processing prower /time when it could read from the cache.

So my question: how can I ensure that caching is enabled and that I have it setup properly.

the LSCS technical reference I downloaded off the site didn't really help .

thanks.

-
John

Find more posts tagged with

Comments

Rick Poulin

how can I ensure that caching is enabled and that I have it setup properly.

There is no OOTB caching for LSCS queries. You have to build it into your externals either custom and/or using one of the provided libraries (JCS, ehcache).