Hundreds of queries are going to kill performance, no matter how you are going to do it
On Mon, Apr 12, 2010 at 9:45 PM, Peter Smulovics <[email protected]>wrote: > Since that I tried everything from creating a new Junction type to native > sql, none of them worked. Now I'm sticking with running multicriteria, and > executing plenty of queries... which kills performance. > > > On Wed, Apr 7, 2010 at 21:31, Ayende Rahien <[email protected]> wrote: > >> Can't you use a disjunction? >> >> >> On Wed, Apr 7, 2010 at 10:05 PM, Peter Smulovics < >> [email protected]> wrote: >> >>> hi! >>> >>> I have a case when I have hundreds of criterias, all of them quering >>> the same type, each of them returning the top 1 result depending on >>> various orders and where qualificants. What I need is the ability to >>> create one huge criteria from them, returning only the top 1 row from >>> their results' union again depending on various orders and where >>> qualificants. I know that criterias don't support subcriteria union >>> now - but is this on the roadmap? if not, do you think it can be done >>> easily? I was thinking about that this differs from criteria junction, >>> but similar to some of the property projections with subqueries... >>> >>> Peter >>> >> >> > -- To unsubscribe, reply using "remove me" as the subject.
