Hi everybody, I would like to know if does make sense to use Solr in the following scenario: - search for large amount of data (like 1000, 10000, 100000 registers) - each register contains four or five fields (strings and integers) - every time will request for entire result set (I can paginate the results). It would be much better to get all results at once - we need to process the entire set in order to decide which ones will be returned - this kind of request will happen frequently in several machines (several transactions per second) - solr machines and request machines will be in the same cluster - we would like to get the entire result set in less than 500ms.
Thanks in advance, Eloi