[
https://issues.apache.org/jira/browse/ISIS-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andi Huber updated ISIS-2888:
-----------------------------
Summary: [Performance] Use EclipseLink for caching of "findByUsername" and
similar security queries. (was: Use EclipseLink for caching of
"findByUsername" and similar security queries.)
> [Performance] Use EclipseLink for caching of "findByUsername" and similar
> security queries.
> -------------------------------------------------------------------------------------------
>
> Key: ISIS-2888
> URL: https://issues.apache.org/jira/browse/ISIS-2888
> Project: Isis
> Issue Type: Improvement
> Reporter: Daniel Keir Haywood
> Priority: Minor
> Fix For: 2.0.0
>
>
> observed numerous calls to findByUsername going to the database,
>
> Have tried various configuration settings to change EclipseLink cache
> behaviour but they don’t seem to make a difference.
>
> One of them was trying to use QueryMonitor to log cache hits but couldn’t
> make that output anything. Simple observation of the page showed by rough
> count of time that page load didn’t vary with different configuration
> settings.
>
> Perhaps @Cache is required on ApplicationUser?
>
> Earlier attempts to use QueryResultsCache didn’t work out either since hit
> the issue with ObjectBulkLoader
> (https://issues.apache.org/jira/browse/ISIS-2330); but think more important
> is using EclipseLink caching.
> Using that caching would be more likely to make a big difference and dealing
> with clearing the cache can be done at a later date if we need to write
> direct to the database.
>
> Any luck with settings to log output from EclipseLink’s QueryMonitor or
> PerformanceMonitor?
> ~~~
> addendum; things attempted:
>
> - various EclipseLink settings and did find with
> eclipselink.profiler=QueryMonitor that I could reload the dashboard page and
> see some output.
> This showed that caching was happening for primary key based requests but not
> others.
>
> - Using XML to configure the named queries gave an error about the class not
> having an id and seemed to be to do with the inheritance and where things
> were set - various combinations of which class used didn't help.
>
> - tried to no avail finding a way to have my own named queries so I could
> set the hint on them.
>
> - tried again with wrapping the findByUsername with queryResultsCache but
> that gave errors about not being in an interaction context when setting up
> queryResultsCache bean.
>
>
> Final solution that was hacked: rudimentary caching in overridden version of
> AuthorizorSecman.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
