Joined: Mon Sep 08, 2003 5:47 pm Posts: 9 Location: Denver
|
I'd like to be able to fetch a List of Lists.
I've got a one to many OBJECT relationship where only the many side is persistent - so there is no DATABASE relationship.
I know I can do the following:
session.find("from DataRecord as datum where datum.time = 87394875");
and get back a single list of DataRecord instances... but it would be great if I could somehow do something like:
session.find("from DataRecordList as drList where drList.timeKey in (98734987,9834793,9389453)");
and get back a List of Lists of DataRecords.
I may be off my rocker but what I'm trying to do is have one thread fetching data lists and another processing them - I'd like the fetches to produce enough data to keep the processing thread busy while waiting for the next batch from the database.
I am conjecturing that the time required to execute a query returning 100 sets in a result is faster than executing 100 queries. I'm going to test that now.
Advice?
Thanks!
- Chris
|
|