I am generating trade signals from a separate server, which gets uploaded to a MySQL database.
Right I am running an EA script, and essentially at every tick I am detecting for changed in the database. If a new signal is uploaded, it will be picked up by the EA script and it will trade based on that information.
However, it feels inefficient to constantly check the database at every tick. Is there a better way to do this? Meaning, is there something that I can write in C# or some external script so that when new data gets uploaded to the database, it in returns activates a script in MetaTrader?
Any thoughts on this would be much appreciated. Thank you!