mercredi 30 mars 2016

Fastest NoSQL wildcard search DBMS?

This is not a subjective question. I'd like to know objectively, what is the fastest at searching both:

  1. "search string" + wildcard
  2. wildcard + "search string" + wildcard

Constraints:

  • Limit to first 20 results (1 preferred over 2, aka run "search string" + wildcard before wc+ss+wc and only if 20 results not found for first)
  • 100,000 rows in db (non-changing)

This database would be very heavily used for searching only. Trying to switch from MySQL to a single file that can be implemented more easily in an executable or towards mobile development. If MySQL servers can be packaged that would work too, but from what I can tell that is a whole complex mess of it's own.

Do these features exist in somewhat reasonable performance in any database not requiring a server? So far we are working with key value store and trying to create multiple databases to parse search queries, but obviously that takes up a lot of hard drive space.




Aucun commentaire:

Enregistrer un commentaire