Cache: depends on how you configure it and which of the different caches that you talk about (level 1 cache, level 2 cache, query cache, generic Java heap, etc.). Generally it will be "in system memory" yes, because that tends to be the fastest medium to read from.
Query processing: well that's vague too as when talking about Hibernate then generally there are also multiple forms of query involved; HQL named and unnamed queries, criterias, generated SQL, stored procedures. Depending on what you're talking about and the runtime environment there may be multiple CPUs spanning multiple systems and networks involved even. Usually it will be some form of CPU or multiple CPUs involved to do the processing, but nowadays you might have a setup where even the GPU is also sharing in the workload.
Rather than asking open-ended questions, you may want to clarify why you're asking this. That makes it easier to reason what kind of answer you're actually looking for.
No comments:
Post a Comment