i want to make my threads content searchable with full text search engines like solr.
but i wonder one thing. should i index just the thread.title, thread.body and post.body or should i index username, created date, nr of posts, views, country, region and city too that belongs to thread?
i mean when an user search for a thread he will get hits returned containing thread title, 2 lines of body, which user has posted it, creation date, tags, and so on.
should i index all this information too? but then it would be pretty much the whole database. or should i just index the 3 first columns i mentioned for full text search.
and another question. when an user post a new thread, then i have to immidiately tell solr to add that row? if im not, how would it be searchable?