We run a search engine for second hand products. We have about 500 million ads in the database which runs on Apache Solr 6 with 2 shards. These ads highly rotate every month, which cause a lot of update and select (about 50 / seconds).
We have some performance issues. We would like to update the data in less than 200ms and select the data in less than 100ms. We have specific filtering/faceting such as : sorting, filtering, geolocation but also paging.
We need expertize of an Apache Solr consultant to improve the performances and stabilize the activity. If the collaboration goes well, we have more projects : relevancy improvement, deduplication, etc.