> Can you define or give an example of what you mean by "hierarchical" queries?
Good question, I think Erik Hatcher had more ideas on that. I was imagining joins or sub queries like SQL does. Clearly they won't be efficient, but it's easier than implementing joins (or is it) in SOLR? Joins limit scalability that is true, I guess it's just the nature of it though. Unless there is some other way to do it. Doesn't Oracle implement some sort of distributed join in their clustering solution? Is it worth it? On Wed, Sep 17, 2008 at 12:25 PM, Yonik Seeley <[EMAIL PROTECTED]> wrote: > On Tue, Sep 16, 2008 at 10:12 AM, Jason Rutherglen > <[EMAIL PROTECTED]> wrote: >>> SQL database such as H2 >> Mainly to offer joins and be able to perform hierarchical queries. > > Can you define or give an example of what you mean by "hierarchical" queries? > A downside of any type of cross-document queries (like joins) is that > it tends to limit scalability. Of course, I think it's acceptable to > have some query types that only work on a single shard, since that may > continue to cover the majority of users. > > Along the same lines, I think it would be useful to have a highly > integrated extension point for stored fields (so they could be > retrieved from external systems if needed). > > -Yonik >
