On 2014-06-24 14:54, Mike Copeland 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?
Contrary to the rumors, I don't think the VFP timer was expensive in
terms of resources if you were polling every minute or two. That said,
I'd suggest Computer #1 update something in the database and have
Computer #2 call a stored routine that queries that special somewhere
for such an indicator flag. As for network traffic, this approach
wouldn't cause much traffic at all, imo.
hth,
--Mike
_______________________________________________
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/[email protected]
** 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.
