Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improvement: Possibility to use full-text-search features of mongodb or mysql #48

Open
PatrickHuetter opened this issue Jul 31, 2014 · 0 comments

Comments

@PatrickHuetter
Copy link

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):

db.person.find({ $and: [{$text: { $search: "freddy" }}, {termCount: {$gte: 3}}] })

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant