we currently use a relational system, and it doesn't perform. Also, even though a lot of our queries are structured, we do combine them with text search, so for instance, there could be an additional clause which is a free text search for a favorite TV show
---------------------- I had exactly the same thought. That query is not an information retrieval (text search) query. It is data retrieval and would work great on a relational database. wunder
