MongoDB uses non-optimal query indexes because of sort about mongoose-datatable HOT 6 CLOSED

@eherve So when will this be seen in new version of plugin?

from mongoose-datatable.

I’ll publish this week on npm
I’m rewriting the plugin to use lookup for populated fields and I’ll integrate your dev as well.

Thanks by the way

from mongoose-datatable.

No problem. This plugin is awesome and works like a charm. There is only one other plugin that enables serverside datatables processing in node + mongo but it does not have all the features this one has (except that one doesn't use aggregation pipeline, but instead uses normal .find().sort().skip().limit().... query). So I rather fix this plugin that works better and only has one minor issue and it isn't even plugins fault (it's MongoDB's). So after I spent 3 days analysing what is happening and optimizing indexes on our DB and still had no success at speeding up some queries I dug deep and found MongoDB bug that is mentioned in pull request. And decided to fix this plugin.

So looking forward to new release so I can update and hopefully have some speedier results. Hoping I will be notified for new version (Will close this issue once new version is out).

from mongoose-datatable.

Thanks,

I just published the version 1.0.7 on npm.
Let me know if it is ok.

from mongoose-datatable.

Version is OK.

from mongoose-datatable.

You can test the next version (2.0.0) by adding it to your projet if you want : npm install --save git+ssh://[email protected]/eherve/mongoose-datatable.git

from mongoose-datatable.