Greetings ObjectDB team,
All below questions assume a very large database (~1,000,000,000 objects):
Q1: Two queries with a big overlap between their result sets. If I query the first set and hold the results in memory somehow, would that speed up the execution of the second query since many of its result objects already created and reside in memory ?
Q2: Do I need to manually use strong references to such cached result objects ? or do ObjectDB exploits frequency of querying such objects and keep them in memory longer automatically somehow before GC takes place ?
Q3: What is the maximum memory size of ObjectDB L2 cache or EntityManager context ?
Q4: Would paging result sets via setFirstResult and setMaxResult speed up the query execution since there are fewer result objects to bring into memory ?