advice to optimize some special scenes or queries
Author: Nyx2022Created Nov 19, 2025Updated Nov 19, 2025
Labelscode/enhancementnot ready
What should be done?
hello,i'm using ferret to replace mongodb,but i find it has some the same problem in mongodb.so i think ferret can do better than mongo,so that ferret may have more users from mongodb
the following environment is there are 20w rows in mongodb as postgresql as backend in Solid State Drive
- the first is
BulkWrite(https://www.mongodb.com/zh-cn/docs/drivers/go/current/crud/bulk/), when is bulkwirte 20w+ updates into ferret,it will cost several hours,even one day - the second one is stat,which is the
Aggregate(https://www.mongodb.com/zh-cn/docs/drivers/go/current/crud/query/retrieve/#aggregation). i think it may be a index usage is relational db,so when the data is big,it will be very slowly,which exist in mongodb ,too,but it actually a bad experience - the third one is query performance(Find:https://www.mongodb.com/zh-cn/docs/drivers/go/current/crud/query/retrieve/#find-multiple-documents), when i wanna use $regex to search in ferret,it will cost a little long time
the above is my common situations in using mongodb or ferret,so i wish ferret can optimize them with the performance of relational db lke postgres,thank you in advance
Source: FerretDB/FerretDB