At 11:54 2014-06-24, Mike Copeland <[email protected]> wrote:
Simplified scenario...
2 Windows computers using a VFP9 SP2 application, served by 1 MySQL
(MariaDB) server on Linux box
What is the best way for computer #1 to "do something" and have
computer #2 detect that change?
(for example, save a new record on the server for a processed shipment)
What my feeble mind has thought of so far...
-- #2 uses a timer to query the server for changes (lotsa traffic!
especially with dozens of workstations)
-- #1 'signals' #2 somehow using Windows API (never done anything like this)
-- a better way I'm oblivious to (no surprise!)
Is there a better way?
Oh, probably. What definition of "better" do you have in mind?
Since MariaDB is multi-user, one possibility is to use a database.
Computer 1 can add a transaction-worth of data to a StuffDone table.
Computer 2 can read that transaction-worth of data from
StuffDone (and possibly delete it when it has finished processing
it). Computer 2 can keep track of which transactions it has dealt
with in a second table.
Computer 2 can poll every so often. Even if Computer 1 can
trigger Computer 2's action, polling by Computer 2 is a good idea,
because what if Computer 1 does not send the trigger or Computer 1
does not receive it? (Think crashes, etc.) I would do both.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
