All good to hear, Mike (opinions and everything.)
I was just curious if anyone was aware of a methodology similar to what
I think is called "push" in the world of html...where a website server
can tell your browser to update the page contents because the website
server, uh, because it wants the browser to update! (usually due to new
content.) I confess I only paid attention out of the corner of my ear
when all the "gee-whiz" of website-push technology was formulating a
decade or two ago.
I know that a simple, small query that returns little data is fast and
efficient...I was just hoping that there might be an even more efficient
communications model for a server to notify "anyone interested enough to
subscribe" that relevant data had been updated. But as I think that
through, it would require that the application (VFP) is 'listening' or
it wouldn't work.
Thanks to everyone for their confirmations, suggestions, and guidance!
I was simply 'wondering out loud' if such a process was possible
(communicating upstream from server) between MariaDB and VFP. I can see
a lot of places it would be useful, but what triggered the question is a
simple scenario where a manager would be monitoring as minions process
inventory returns...looking for anomalies and incomplete data. The
returns are on-going all day long and can sometimes not 'happen' for
several hours, or there can be two dozen in 10 minutes. It is really
nothing more than a simple monitoring process.
Firing a timer to query every X minutes/seconds is no problem. Just
thought a 'server->client' scenario would be sexier!
Mike
[email protected] wrote:
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.
