Here’s the situation. I have a long query (you may remember my post from last week, well I was unable to optimize despite all attempts and I need a solution even if temporary) that takes a long time to load, which really slows down our program.
Instead of referencing the query directly, I’m making a historicTable with the results of it (the table isn’t updated more than a few times a day anyways). When any of the underlying tables is UPDATED, INSERTED, or DELETED from, I’m setting up MySQL to recreate the table.
Now this is what I am wondering - one client edits or updates one of the tables, and my historicTable gets recreated. Is there any way for the gateway to tell all the other clients to now refresh that table (if they’re on the screen)?