http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660@Fujiy One reason to have tags inside the Query field and outside is to allow for a search all in one field (Query) and also support explicit tag searches (just want the tag 'Finance' not something with Finance in it's title) It can also mean you can sort by tag (albeit the first one only)http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment5http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment5Tue, 04 Sep 2012 00:32:06 GMTWhy are you indexing p.Tags inside the Query property and outside too? RavenDB supports filtered indexes? It can achieve impressive performance boost sometimes, decreasing the index size from thousands or millions rows to dozens rowshttp://ayende.com/158211/nugget-perf-part-v-searching-packages#comment4http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment4Mon, 03 Sep 2012 14:34:33 GMTJohn, Yes Lucene handles substring, regex and levensteihn string relations through the FuzzyQuery and WildCardQuery. They are not as quick as pure index-lookups but they are quite quick after version 4.0 introduced a levensteihn automata to do the job of comparing an index term with a search term.http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment3http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment3Mon, 03 Sep 2012 11:33:06 GMTThey could implement poor man's keyword search in SQL by creating a table that maps keyword->package Id (an inverted index for packages). For such a simple database there shouldn't be any problem with performance or with keeping the index up to date.http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment2http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment2Mon, 03 Sep 2012 10:52:50 GMTAh, but does this find a package named 'MyJQueryExtension' ? I understand that substring searches are not always a good idea, but in this case you're not replicating the search. Can RavenDb and/or Lucene handle substring searches?http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment1http://ayende.com/158211/nugget-perf-part-v-searching-packages#comment1Mon, 03 Sep 2012 09:56:39 GMT