StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCaching data in grails
text
Body
copied!<p>I have a site where users will first enter their search criteria. The search combines data from 2 sources, one of which is not a database. The search results are generally large enough to be paged.</p> <p>Since the initial query is expensive, I would like to cache the search results if the search criteria doesn't change for subsequent page views.</p> <p>My current method looks like:</p> <pre><code>def search(criteriaMap, offset, pagesize) </code></pre> <p>What is the best way of caching the search results in groovy/grails? How would I expire the search results? </p> <p>Note, I see there is a springcache plugin but I am not sure if this will work for paged results. I also know that grails is packaged with ehcache but I haven't seen an API I directly have access to, I have only seen it used for 2nd level caching with GORM.</p> <p><strong>Update</strong>: I took part of @mfloryan's solution to solve this.</p> <p>I created two methods in the <strong>searchService</strong>:</p> <pre><code>@Cacheable("searchCache") def searchResults(uid, trimmedParams) def trimParams(params) </code></pre> <p>(One is cached and the other is not.)</p> <p>My code in the <strong>searchController</strong>:</p> <pre><code>def trimmedParams = searchService.trimParams(params) def results = searchService.searchResults(trimmedParams) //Page results results = HelperService.pageResults(results, params.offset, params.max) [results: results, searchParams : trimmedParams] </code></pre> <p>As a results, I invoked the search service with a trimmed list of parameters that do not include paging params. The cached search results can be returned.</p> <p>The searchController takes care of the paging.</p> <p><strong>note</strong>: I didn't cache the hibernate results because I would end up with double the data in the cache. I only cached the combined results from searchService.searchResults (which hits a REST API and my local database)</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload