Hello I am trying to indexed structured data, kind of event log (user, client, serverIP, time, etc.); I would like to enable specific field search (e.g., user = John Smith) and free text search (e.g., John Smith).
I've tried to index each field seperately and all string together in another field to allow free-text. With 1 million documents where a document represents one event (pretty short), the performance are very poor. - The field search is fast but when search the full string field it is pretty slow (around second). - I've implement the Cloud, when I try two machines with 1 millions documents, the Pivot search is very, very slow. In the past I did it with pure Lucene and it was pretty cool, 160millions document were pretty fast for free text search. Thanks in advance Oded