You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Querying strings in mongodb can be slow on large datasets.
If you create a text-index on the field you want to query and use the "text"-operator to query your dataset, it's extremly fast. I improved some queries from 30 seconds to under 1 second until response.
Example Query wich takes 0,095 seconds (same Query without using the text index takes 30 seconds on our database):
I hope it will be build soon or i'll look for it. It would be fine if filterpane could build a flag controlled feature on that, so that users who have a text-index, can make use of the fast query option. (Maybe filterpane could get the information from the domain class, where the text-index is defined).
Similar features are also available in the mysql-environment.
The text was updated successfully, but these errors were encountered:
Querying strings in mongodb can be slow on large datasets.
If you create a text-index on the field you want to query and use the "text"-operator to query your dataset, it's extremly fast. I improved some queries from 30 seconds to under 1 second until response.
Example Query wich takes 0,095 seconds (same Query without using the text index takes 30 seconds on our database):
It seems that there is no fulltextsearch-operator in mongodb-gorm now:
https://jira.grails.org/browse/GPMONGODB-396
I hope it will be build soon or i'll look for it. It would be fine if filterpane could build a flag controlled feature on that, so that users who have a text-index, can make use of the fast query option. (Maybe filterpane could get the information from the domain class, where the text-index is defined).
Similar features are also available in the mysql-environment.
The text was updated successfully, but these errors were encountered: