query-cache
NHibernate best practices (Query cache with much static data)
We have a situation, where we feel we do not fully take advantage of NHibernate\'s capabilities, which reduces performance. The actual situation is reduced to a \"blogs with posts\" example for this q[详细]
2023-01-05 03:53 分类:问答MySQL query cache vs caching result-sets in the application layer
I\'m running a php/mysql-driven website with a lot of visits and I\'m considering the possibility of caching result-sets in shared memory in order to reduce database load.[详细]
2023-01-01 04:36 分类:问答How does Query caching improves performance in nHibernate?
How does query ca开发者_StackOverflow中文版ching works and how does it improves performance in nHibernate?When a query is cached, NHibernate will cache the IDs of the entities resulting from the query[详细]
2022-12-21 21:38 分类:问答Hibernate - query caching/second level cache does not work by value object containing subitems
I have been struggling with the following problem: I have a value object containing different panels. Each panel has a list of fields.[详细]
2022-12-19 09:10 分类:问答Hibernate query cache - for objects not in the 2nd level cache - risky? useful? bad practice?
Related to this question Premise: These are my assumptions, based on my reading, experience and understanding, they may be wrong, if they are, please comment and I\'ll edit the question.[详细]
2022-12-15 04:17 分类:问答Hibernate Second-Level Query Cache not working Eager Fetching
In NHibernate Profiler I observed that when I use eager fetching on an association, using \"left join fetch\" in an HQL Query or .SetFetchMode() in a Criteria Query the query no longer gets cached in[详细]
2022-12-11 22:42 分类:问答