News for hackers. Stuff that matters.
Re:How MySQL memory table saved the day by herge on Friday December 13, 2013 @09:26AM (#6900589)
Does Elasticsearch or Solr work with tabular data, can you search across multiple columns?
Re:How MySQL memory table saved the day by arethuza on Friday December 13, 2013 @10:19AM (#6900903)
Lucene models documents as a collection of fields, each with a textual value.

http://lucene.apache.org/core/4_0_0/core/org/apache/lucene/d...

At search time you can use the default field or specify the fields to be searched:

http://lucene.apache.org/core/2_9_4/queryparsersyntax.html#F...

Re:How MySQL memory table saved the day by Xylakant on Friday December 13, 2013 @09:37AM (#6900650)
I can't speak well for Solr, but with elasticsearch the answer depends on what you exactly mean with "search across multiple columns", but it's probably yes.
Re:How MySQL memory table saved the day by waterlion on Friday December 13, 2013 @11:05AM (#6901178)
Yes. Read the example SOLR schema, it's very easy to understand.
Re:How MySQL memory table saved the day by Tomdarkness on Friday December 13, 2013 @09:37AM (#6900646)
Yes you can, and a whole lot more.