Hello and good day!
Just like what the title says, I humbly request for you guys' expertise and a healthy, bountiful discussion regarding this....
My team has 2 indices called "web" and "socialmedia", both of them got their data / documents from a MySQL Databases that has collected millions of data since year 2015.
Now our IT Head is planning up to create micro indices that would chop or chunk these 2 BIG indices into smaller ones -- whereas we'll be dissecting each of them per months.
Here's the idea, for example, the "web" index has a whole set of year 2019 data / documents, and we're planning to chunk these data into chunks each month, from "web" index to -> "webjan2019", "webfeb2019", "webmar2019" (meaning, a lot of data with a "time" falling for a specific month would belong to a specific micro index) and so on...
Now back to the main questions:
- Would there be a big impact or big improvement if we'll be performing the aforementioned idea?
- Would there be heavy drawbacks by doing so?
Thank you very much in advance, I greatly appreciate your invaluable expertise!