Does anyone have experience using Apache Lucene as the main data provider?
Screwed we mean Apache Lucene to your application. Use it for full-text search system. You know, it's like the input at the top of the "Find question, answer, tag or user." And then the question arose, is it possible to use Apache Lucene as the underlying data source? Ie not to go into the database for the data from the word altogether. The application from the "bloody enterprise" - SED. Data is becoming more of the selection become slower. It is clear that you can optimize the queries, to optimize the DBMS itself. But Lucene not bad job of quick access to data according to specified criteria.
Actually I would like to hear tips on using (or not using) Lucene or similar engine as the primary data source for the application.
Had experience with elasticsearch, but not as primary storage.
Connecting the team used as the primary, then their words (for what bought for sell).
The experience was rather negative. Had problems with reliability, backups, etc. the Data is denormalized, if not - it will be a big problem to adjust. A couple of times indices broke. In the case of tradicionnoj RDBMS as primary storage, would just start reindex. And then the full, sorry, ass. More they do not.
estrella.Schiller80 answered on August 19th 19 at 22:57
Not giving proof, but it seems a widespread opinion that to use Lucy as the main store there's a way to shoot yourself in the foot