http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Alex, Yes, you can only query by PK http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment11http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment11Fri, 15 Oct 2010 01:20:37 GMTIs it enforced to be get by key? (basically I'm wondering if someone would actually be able to shhot himself in the foot with this feature, by emiting non key subqueries) http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment10http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment10Fri, 15 Oct 2010 01:13:52 GMTAlex, Yes & No. What this actually generate is a load by ID, which is about as fast as you can get it. As I mentioned, this is basically a nested loop join http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment9http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment9Fri, 15 Oct 2010 01:04:00 GMTI might be misreading this, but isn't this generating an 1+N query? While the good part is that it happens server side, so you avoid network roundtrips, it will still generate N additional reads. http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment8http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment8Thu, 14 Oct 2010 22:20:15 GMTFor indexes, yes. Because the naming conventions turns them into: "Users/ByAlias" http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment7http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment7Thu, 14 Oct 2010 11:30:48 GMTAyende: just a question about classes naming. Users_ByAlias: do you recommend naming classes with an underscore? http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment6http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment6Thu, 14 Oct 2010 11:27:44 GMTDerek, The TransformResults function is called when you query the index, it is not persisted. And the fact that you can do that is simply because the anon type & the UserAndAlias has the shape shape http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment5http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment5Thu, 14 Oct 2010 10:13:51 GMTNice. How do you end up with the UserAndAlias type at the end when your transform's just creating an anonymous type? Is the index persisted and maintained or just created for this one query and, if it is persisted, what happens when you update the code for the index creation task? http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment4http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment4Thu, 14 Oct 2010 09:23:05 GMTwow, that is a really useful feature! Ayende: respect;) http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment3http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment3Thu, 14 Oct 2010 09:18:03 GMTThis is one of my favourite new things ever :D :D (Okay, I'm still a little excited too!!) http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment2http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment2Thu, 14 Oct 2010 09:06:54 GMTVery useful. This can probably be materialized as well. http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment1http://ayende.com/4661/ravendb-live-projections-or-how-to-do-joins-in-a-non-relational-database#comment1Thu, 14 Oct 2010 09:06:46 GMT