Change Charts Query Order and Timeout
I use charts as an iFrame embedded to my website, and our clients ( another Team inside my company) should always analyse different user IDs data. Having that in my mind, I created general purpose graph charts and when used, the query inside the iFrame would query the user IDs wanted.
The problem is that, your mongoChart would first do all query inside the Charts ( Query and Filters) and then filter the document (on iframe code) that should have been filtered before. The result is that, even for a small collection ( 1 million documents 200mb size) a chart wouldnt load. I am losing a lot with that, searching for new tools that could do that without a problem, after all, if I do the same aggregation with my pymongo it takes 0.5 seconds! And your mongoCharts wouldnt complete the task.
Please help, I use mongo Atlas and using Charts would make my life easier.
Vinícius
shared this idea
-
Vinícius
commented
if I sample my database it still works but my data isn't reliable at all, so yes, you solution doesn't work. Filter pane doesn't work for me, I have too many dashboards and more than 20 charts depending on which product we are using, and it doesn't even have authentication and any security implemented yet, so yes not reliable practical and safe. I can't use that.
I understand my requirements would make change your solution but I think it would help a lot of customers that want to follow the same path I am following.
Another important thing is, I work at small company and I have a small database to work with (In this example only 3MM documents indexed, and not even 1 year o data) and it doesn't work, imagine this solution in medium or large company, unusable. And it doesn't make any sense to make to scale my M20 to a M30 just to make my charts work, it get too expensive and it would make more sense to go to other solutions available on the market.