Bug 293728 - Query cache options
Summary: Query cache options
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: James Sutherland CLA
QA Contact:
URL:
Whiteboard:
Keywords: performance
Depends on:
Blocks:
 
Reported: 2009-10-29 15:56 EDT by James Sutherland CLA
Modified: 2022-06-09 10:10 EDT (History)
1 user (show)

See Also:

Attachments
patch (31.92 KB, patch)
2009-11-02 09:52 EST, James Sutherland CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description James Sutherland CLA 2009-10-29 15:56:06 EDT 
Enhance the existing query cache with the following:

- an option to ignore caching of null, this improve the ability of using the query cache for a secondary key index
- allow the cache type to be set, currently it uses the CacheIdentityMap, but Full or Soft would also be desirable
- allow the invalidation time to be randomized, this helps with server bottlenecks by avoiding everything becoming invalid at the same time
Comment 1 James Sutherland CLA 2009-11-02 09:52:23 EST 
Created attachment 151074 [details]
patch
Comment 2 James Sutherland CLA 2009-11-02 09:57:11 EST 
SVN main commit: Bug#293728 - Query cache enhancements

https://bugs.eclipse.org/bugs/show_bug.cgi?id=293728

Code review:  Andrei (pending)

Changes:
- Adds support for setting cache type on query cache.
- Adds support for ignoring null results on query cache.
- Adds support for randomizing invalidation, to avoid invalidation bottlenecks.
- Adds query hints for new query cache options.
- Updated query cache test.
Comment 3 Sebastien Tardif CLA 2009-11-02 17:42:39 EST 
Last time I tried query cache it was locking coarse grain so was blocking lot of concurrent similar requests.

Also it seems unlike Hibernate that the query cache is not automatically invalided when what is referencing is updated by a transaction.

Please consider fixing both issues.
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:10:01 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink