The cursor is terminated when the If there is a single customer with first name "mickey" and he has five accounts, the above snippet results in six database hits.
One common case where this can happen is if the database is sharded.
In this case, the connection manager's job is to return a shard-specific database connection.
Sharding is discussed in more detail in other Reladomo documentation. The following snippet shows a runtime configuration where all the objects are partially cached.
This means that Reladomo will cache an object as long as there is sufficient memory.
When there is a memory crunch, the cached objects will be garbage-collected.