Although coming primarily from SDM, I see this as applicable to any component that uses the MDB.
There is a huge wealth of information in the text fields of tickets. The problem is that it is unstructured and non-indexed making the normal queries inside the application a huge performance problem and actually impacts operations if used on production tables.
We try to minimize the queries by having users base their queries on the indexed fields first and then acting on the text of the results; forcing text based queries to replicated database instances; etc.
If an organization has the people and resources they can take database measures to improve performance or limit queries but not all businesses have this capability.
I'm looking for input from the communities on how they are using the application to query and act on the text fields.
I'm also looking for suggestions for Ideas for improvement such as how the current MDB could be integrated with MS SQL Full-Text Search and extending Federated Search to results for use by Knowledge Management SMEs to curate knowledge documents.
J.W.