[SERVER-21967] mongodb regex without prefix performance issue Created: 21/Dec/15  Updated: 21/Dec/15  Resolved: 21/Dec/15

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 3.2.0
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: shaker Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

I have performance issue when I try to use regex to do search for part of name
example: db.names.find({name: { $regex: "ALEXANDER" }})
(RDBMS: where name like %ALEXANDER%)

What is the best practice to do similar search.



 Comments   
Comment by Kelsey Schubert [ 21/Dec/15 ]

Hi shaker.shady,

Thanks for your report. Please note that SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-users group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-users group.

Regards,
Thomas

Generated at Thu Feb 08 03:59:00 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.