Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
mongodb-user
Home
+ new post
About this group
Join this group
Performance on regex finds with %LIKE% semantics
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
zatter99  
View profile  
 More options Sep 24 2010, 2:26 am
From: zatter99 <fr...@soetebeer.com>
Date: Thu, 23 Sep 2010 23:26:56 -0700 (PDT)
Local: Fri, Sep 24 2010 2:26 am
Subject: Performance on regex finds with %LIKE% semantics
Print | Individual message | Show original | Report this message | Find messages by this author
Hi everybody,
what is the best way of getting apprpriate find performance on such a
query

db.collection.find({name: /findstring.*/})

on a collection of more than 2M rows?

Indexes cannot be used I assume.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Dirolf  
View profile  
 More options Sep 24 2010, 9:43 am
From: Michael Dirolf <m...@10gen.com>
Date: Fri, 24 Sep 2010 09:43:25 -0400
Local: Fri, Sep 24 2010 9:43 am
Subject: Re: [mongodb-user] Performance on regex finds with %LIKE% semantics
Print | Individual message | Show original | Report this message | Find messages by this author
Correct, an index won't be used unless you to a prefix match
(/^findstring/). There's a lot of factors involved so I'd recommend
testing to see how it performs for you.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Andreas Jung  
View profile   Translate to Translated (View Original)
 More options Sep 24 2010, 9:47 am
From: Andreas Jung <li...@zopyx.com>
Date: Fri, 24 Sep 2010 15:47:27 +0200
Local: Fri, Sep 24 2010 9:47 am
Subject: Re: [mongodb-user] Performance on regex finds with %LIKE% semantics
Print | Individual message | Show original | Report this message | Find messages by this author

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

zatter99 wrote:
> Hi everybody,
> what is the best way of getting apprpriate find performance on such a
> query

> db.collection.find({name: /findstring.*/})

> on a collection of more than 2M rows?

> Indexes cannot be used I assume.

MongoDB does not provide a fulltext search engine.

Consider usingan external search engine like SOLR or ElasticSearch.

I think fulltext search is planned for a further release (perhaps even
for 1.8).

Right now there is no efficient way to use right truncation with
MongoDB's query capabilities (except you reimplement an indexing
structure for right truncation yourself in MongoDB).

- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMnKvvAAoJEADcfz7u4AZjD9ILwIiVHfwcb1/+4tz9goJqvQBC
PnmJWjxdKARNTg3Yh3DrCp5dvc1COGbxPucBL0nvMB7CqMO7PV795dCYDCcOaxrK
frKDxi/+8acTQ7+T+djRooXU/eBW0bMgmthRQLW0ZryzC+AZb6VE3FOImMWFa2Ey
fnJim2Z5QAhQvzojqb9/NxRaODbmNsptgCyt/CjCZ3roUvoXu0xnVGFVDwLkLNcD
gptvbsSvGP5CZMTq5PaDuPl+Q8tUN36KEN8HODx3KzMhjKMAh+NCsgvUQBwu/e1E
Jg+DECbLFRyPY8uGugsgsITM77cjQR/+uenK89OltX0u/F5EqoOvaMjggmQF+eDh
1NpIvsw3RR9SCvS3Iybx9q0J4DWrzelyZMXXeuZb1rlo6HWjypMAKSjz9tOwmNEn
bOREw8PdE9BylbUgDLuCdfa7BBpgWdwtXUkEsE6jQZPdjE3xaz+YfpzqJNR8Kycw
w55zJdrBU4RUw7gtTXQ364lhPcfWK/M=
=sssn
-----END PGP SIGNATURE-----

  lists.vcf
< 1K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
zatter99  
View profile   Translate to Translated (View Original)
 More options Sep 24 2010, 12:34 pm
From: zatter99 <fr...@soetebeer.com>
Date: Fri, 24 Sep 2010 09:34:29 -0700 (PDT)
Local: Fri, Sep 24 2010 12:34 pm
Subject: Re: Performance on regex finds with %LIKE% semantics
Print | Individual message | Show original | Report this message | Find messages by this author
Thanks everybody. This is what I've expected.

It looks like the fulltext search is planned for.1.7.x release.
Whatever x will be ;-)

Looks like we'll have to wait until then.

On Sep 24, 3:47 pm, Andreas Jung <li...@zopyx.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google