Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Firstly, if you want to cache the query, then perhaps using the Hibernate query cache is a good start (Set <code>cache:true</code> in the <code>mappings</code> and pass <code>cache: true</code> to the <code>executeQuery</code>)</p> <p>Using the <a href="http://www.grails.org/plugin/springcache" rel="nofollow">SpringCache plug-in</a> will allow you to cache the entire response from the controller. All you would need to do is decorate the controller like that: <code>@Cacheable("searchMethodCache")</code> or only decorate individual methods that you want results of cached. The cache will save response by query string so it should work well with paging. The <code>@CacheFlush</code> annotation allows to set when the cache should be cleared.</p> <p>The EH Cache itself is configured in <code>grails-app/conf/spring/resources.groovy</code></p> <p><em>-- UPDATE --</em></p> <p>Following you comment I begin to suspect your might be thinking of a slightly different solution. So there is a query that returns a list of results and that list is then paged and displayed. With standard Grails approach Hibernate will generate one query for each page (returning a subset from the full list thus running the potentially expensive query once for each page). Presumably you want the query to be run once - to return the full result set that gets cached and then serve individual pages from the it. If that's the case, far as I know, you will have to page the results manually either from the Hibernate cache or caching the result set somewhere else (Session context?)</p>
    singulars
    1. This table or related slice is empty.
    1. POCaching data in grails
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmfloryan
    1. USmfloryan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCaching data in grails
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHow would the pagination widget interact with this? can I flush the cache based on time or FIFO order?
      singulars
      1. PO
      1. USTihom
    2. COGoing to a different page changes query string so different response is cached and then served. Cache expires automatically so no need to explicitly flush based on time. Just set it in Config.groovy under sprigcache/caches/[cacheName]/timeToLive = ...
      singulars
      1. PO
      1. USmfloryan
    3. COI would like to avoid requery for different pages. How do I do that?
      singulars
      1. PO
      1. USTihom
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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