-Any way to "append" new text to an existing indexed field?
Andy 2010-10-01, 11:38
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?