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

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -