I have a listings page which is built from a query to a query data store (EG: solr) that is updated (in bulk) every 10 minutes from the primary (relational) database.
When a user clicks on 'edit' for a row (or clicks on 'create' to create a ne开发者_StackOverflow中文版w row), after he submits the edit/create form, the row in the primary database is updated in real-time, but the query data store (EG: solr) is not updated for up to another 10 minutes.
The problem I have is that the listings page would still be displaying the stale result set (updated 10 minutes ago), so the user may not see his changed row for up to another 10 minutes.
Is there a way I can ensure that the user will be able to see his changes in real-time, even though the listings page continues to query from the query data store (EG: solr)?
精彩评论