On Feb 7, 2005, at 9:17 PM, Christian Bauer wrote:
On Feb 7, 2005, at 11:08 PM, Adrian Ridner wrote:
Did we miss something? I'll be optimistic and hope we didn't reinvent the wheel, but if we did, it was a fun exercise :)
Read up on the docs some more. What you try to do would create a Cartesian product and be slower than two queries (which is what you discovered will happen). This is documented in every other place and a sensible limitation. You can write a custom SQL query in very special cases, if you are sure the product is faster than two queries.
Thanks for the reply. Sorry I didn't see it before, it got lost in my mailbox. I appreciate your feedback. I guess that answers my original question. We'll read up the docs more to see if we find anything. I am wondering if I didn't communicate what we are doing correctly though, because we are running this on tables with 5,000,000 rows each, and it is faster than anything else we tried.
In any case, thank you for a great product!
Adrian
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
