Asking for better strategy implementing Delphi online reports based on firebird database -


In a firebird database based Delphi application, we need to bring some data online, so we have our application in online-reporting capabilities. can add .

The current approach is: whenever the data changes or is added, they are sent to the online server (php + mysql), if it fails, then adding it to the queue and re- try. Then the server with the data is capable of making its report.

So, to conclude: What is a good way to bring that data online?

  • Event based: Whenever changes are found, For pushing the web server / mysql db, the destination is collected for the message when the message is not received.

  • Snapshot based: Remove the relevant data in the interval (for example every hour) and move it to the web server / ISSLL DB.

The snapshot-based strategy allows data to be pre-processed, which fits well in the wb / mysql DB data structure, which will improve the system and send system ( Delphi) in favor of keeping more business logic. It also generates a more consistent load, because it does not care largely on data changes.


Comments

Popular posts from this blog

paypal - How to know the URL referrer in PHP? -

oauth - Facebook OAuth2 Logout does not remove fb_ cookie -

wpf - Line breaks and indenting for the XAML of a saved FlowDocument? -