4 ms·
No database can be fast without indexes. If the queries you get are defined by your users, you can still create indexes for the common ones.
by lucian1900 12y ago
No database can be fast without indexes. If the queries you get are defined by your users, you can still create indexes for the common ones.
- felipesabino 12y agoThe way business logic in the system is currently designed , there are no 'common ones', except for some ids (already indexed) used in other process rather than this dynamic filter. Based on that we also evaluated the approach of using something else like druid [1] [2] that is built for reading performance, but I am still studying possibilities and have no idea about the impact and problems a change like that would impose. [1] http://druid.io/ http://druid.io/ [2] https://metamarkets.com/2014/building-a-data-pipeline-that-handles-billions-of-events-in-real-time/ https://metamarkets.com/2014/building-a-data-pipeline-that-h...
- lucian1900 12y agoAnother thing to note is that Mongo is simply very slow. Without indexes, something like Postgres is much more likely to be fast.