Update database and ticker simultaneously, saving bandwidth?
I was hoping to gather some opinions on how I'd go about the following:
I'm first looking to create an admin page for admins of my website to update my database (add, edit, delete records). This will be admin.php. The database has three tables - Merchants, Issues, Updates.
I'm also looking to include a ticker (for simplicity's sake, a HTML marquee) on index.php which will contain the last record of certain fields from the database's tables.
The purpose of the database is to record issues with merchants. There are updates to those issues. The ticker is meant to provide live information to my colleagues of new issues.
What is the best way to update the ticker without using much bandwidth?
I have limited knowledge of these things. I can only see two options:
1. Having the ticker check the database every five minutes (bad news for bandwidth?).
2. Make the last update posted through the admin.php form get submitted to the ticker?
Not a fan of option 1 if 20 PC's are doing that.
If I use option 2 and a user logs into my website after the last issue was submitted via admin.php, will they still see it without the script constantly checking the database?
Maybe if when logging in, the script checks the database for the last record(s) once and then accepts new updates via admin.php from that point onwards?
I could probably do it that way and add a manual refresh button for the ticker to call the current last record(s)?
Sorry I'm just thinking out loud here. Please let me know what you think. Thank you.