Minimise delay between Salesforce Streaming API and Heroku Connect

Question

I currently have an app (node.js) running in Heroku, using Heroku Connect to connect to Salesforce to read/write data.

Heroku Connect essentially has a copy of selected data from Salesforce, which is pulled in via the Streaming API.

My application instantly writes to the HC PostgreSQL database, which instantly writes up to Salesforce.

This adds a unique reference field that is also instantly generated in Salesforce, however there is delay in this information being fed back to Heroku Connect.

I'm not sure if the delay is because of the streaming API or Heroku Connect, but I'm not sure how to minimise/remove this delay so that Heroku Connect instantly updates with the newly generated field.

Please take a look at the diagram below showing what is instant and where the delay is happening:

Answer 1

I believe that the cause of such delays can be reconnected and socket timeouts. If your Salesforce side of solution generates events, not that often, the client can miss a connection and might need to reconnect each time and the time can be wasted as well. Possible, solution for such case is to generate fake events on the Salesforce side for keeping an alive connection, but you need to take care of reaching different Streaming API limitations. 

Enroll in this Salesforce Certification to start your journey today!