In a document editing web application such as Google Docs or Evernote, sync/save has to happen almost instantaneously to make sure data loss is minimal in case of a connection failure or a client crash.
A straight forward solution seems like to have the update end point called at short time duration or each time user pauses after typing. To keep this data in sync we will update the database field for the text/JSON data.
How do we better optimize these frequent write/update calls to the database? Is the optimization unnecessary?