0

I'm currently working on a classic MVC project that is handling files.

I have a research screen in my application that is multi-criteria. The resulting request is making like 5 or 6 unions and joins over a big database ( > 5 millions records ). We improved the request with a DBA but the result isn't satisfying.

I was wondering if it's a good idea to back the database with elasticsearch. I'm thinking about indexing each field of thes criterias of that screen in elasticsearch in order to retrieve datas easily.

I would like to know if somebody had already encounter this problem before and how did you solved it.

Thanks.

Kyle_jumpen
  • 111
  • 2
  • 9
  • These answers should help: https://stackoverflow.com/questions/34477095/elasticsearch-replication-of-other-system-data/34477639#34477639 + https://stackoverflow.com/questions/36915428/how-to-setup-elasticsearch-index-structure-with-multiple-entity-bindings/36982705#36982705 – Val Jul 31 '17 at 14:25
  • Hi, Thanks for the answer. These posts show how to set it up but don't explain if the choice is wise considering the performances of the applications. – Kyle_jumpen Jul 31 '17 at 14:33
  • 2
    It's clearly a wise choice, use the technology for what it's good at: RDBMS to store data, ES to search it ;-) – Val Jul 31 '17 at 14:44
  • I have encountered such a problem before and have solved it completely within Oracle DB, with proper logical table organization. How did I solve it, is outside of scope of this web site and the solution to your particular problem might be completely different from the solution I implemented back then. But all in all, be confident about Oracle DB being good enough to do your multi-criteria searches on its own. – peter.hrasko.sk Aug 03 '17 at 09:24

0 Answers0