I'm building a Q&A application. There's a "Question" database table and an
"Answer" table.
For each question, I'm putting the question itself plus all the answers into a
single field "text" to be indexed and searched.
Say I have a question that has 10 existing answers that are already indexed. If
a new answer is submitted for that question, is there any way I could just
"append" the new answer to the "text" field? Or is the only way to implement
this is to retrieve the original question and the 10 existing answers from the
database, combine them with the newly submitted 11th answer, and re-index
everything from scratch?
The latter option just seems inefficient. Is there a better design that could
be used for this use case?
Andy
