Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Mike Yearwood
 To: Glenn Gevero
  Where is Glenn Gevero?
 Glenn Gevero
Subject: RE: About Timer
Thread ID: 310636 Message ID: 310703 # Views: 49 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Thursday, June 23, 2011 4:10:45 PM         

> Hi experts,
> I posted a message yesterday regarding the timer control and got the answer and it solved my issue. However i want to ask from your best opinion regarding the use of the timer control.
> I decided to use timer control in my dashboard form to have the data in my dashboard requery automatically thus giving the enduser updated dashboard every 1 minute.
> My question is: If my application is doing a requery to the server every 1 minute to get updated data to show in the dashboard will it not cause traffic in the network?
> I am seeking for your professional opinion. Thank you in advance.
> ----------------------------
> with best regards,
> Glenn
> Everything is possible if you know how to code it... Therefore keep on learning.
> http://sourceforge.net/projects/sanggre/

Yes, firing the queries by a timer will cause network traffic. Absolutely. Obviously?

Beware "fully optimized". Computers are stupid. To them fully optimized is not the same as fastest possible. SET DELETED is a simple example. If you have a 100mbps network, SET DELETED and a corresponding INDEX ON DELETED() TAG WHATEVER BINARY can help or hurt, depending on the number of records. I tend not to add such an index. I SET DELETED OFF and test my queries for full optimization.

Here's a trick. Make a small table that shows the datetime the last data was added that will affect the dashboard output. All PCs can look at that single record extremely fast. By keeping their own internal record of the last time they refreshed, you could reduce the number of hits against the dashboard tables significantly.

Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.


About Timer Posted by Glenn Gevero @ 6/23/2011 6:04:49 AM
RE: About Timer Posted by Glen Villar @ 6/23/2011 6:11:38 AM
RE: About Timer Posted by Glenn Gevero @ 6/23/2011 6:19:30 AM
RE: About Timer Posted by Glen Villar @ 6/23/2011 6:31:52 AM
RE: About Timer Posted by Glenn Gevero @ 6/23/2011 7:26:51 AM
RE: About Timer Posted by Mike Yearwood @ 6/23/2011 4:10:45 PM
RE: About Timer Posted by Glenn Gevero @ 6/24/2011 3:51:40 AM