Thanks Dan! Appreciate the input!
Mike
Dan Covill wrote:
I'm not a fan of "Push", too many ways for it not to get there. I'd just query
the server.
A few years ago (say, about 20!) I did something like this for a 'live' backup
system. FoxPro DOS system with 30 workstations, traffic got to where daily
night backups just wouldn't cut it. I used a workstation on the LAN and wrote
a program that queried the server every 10 minutes and check the record count
on all the key DBFs. If it was greater than the one on the backup copies
(which it almost always was), I copied the records from (old last rec) to (new
last rec). Worked like a charm, with little/no effect on server response. Had
to start from scratch whenever we packed the server, but that was no problem.
Servers are there to respond, not to initiate actions. Let it do its thing,
and when you want to find out something, just query it.
Dan
Date: Tue, 24 Jun 2014 17:36:40 -0400
From: [email protected]
To: [email protected]
Subject: Re: Is there a better way...
On 2014-06-24 14:54, Mike Copeland 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
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
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.
