skip to Main Content

I have millions of rows of data in MySQL DB. Can you suggest me any services or platforms that support JOINS and fast data retrieval.

I have looked on elastic search and manticore search, but these don’t support JOINS.

So, can you suggest any services or platforms (free or paid).

I have looked on elastic search and manticore search, but these don’t support JOINS.

2

Answers


  1. A couple of points :

    1. For faster searching you need to denormalize data.Read this article to get full clarity
    2. After denormalizing you can use Elsatics search to index the relevent data and search
    Login or Signup to reply.
  2. In addition to answer of Abhimanyu, es is a nosql. So, joins are not present by definition.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search