Yes, you are right. VFP SQL queries can run fast if optimised. We have some vfp code for reports which take more time if we run it locally. For that we do remote desktop to our server machine and run those processes.
As mentioned by others, we can use webservice or COM+ to run this code and get the same result. -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Alan Bourke Sent: Wednesday, December 24, 2014 5:47 PM To: [email protected] Subject: Re: Network Slow Query If your queries are correctly optimised then there is no reason that just accessing the tables in VFP normally would not be fast, even with millions of rows. Occasionally network infrastructure problems get in the way, but that is no reason to start faffing with other methods. The only Tim you should use web services and serialization like XML is when accessing VFP data across the internet. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Tue, 23 Dec 2014, at 10:27 PM, Naeem Afzal wrote: > Hi, > > It's good idea to return only required data between server and clients. > To > speed up vfp tables data access from a windows server to clients (windows > and web), what should one use ? > > A) (1) COM+ OR (2) Web service OR (3) 3rd party tools like > WebConnect / > ActiveVFP / Foxweb > > B) Data format ? XML or Delimited text ? > > TIA > Naeem > > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Christof > Wollenhaupt > Sent: Friday, December 19, 2014 8:36 AM > To: [email protected] > Subject: Re: Network Slow Query > > > Network access speed is largely driven by two factors: What data do I > need > to read at all, and how fast can I get data across the network. For the > network speed the bandwidth is the least important attribute. More > important > are latency and package throughput. > > -- > Christof > > > --- 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/ ** 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.
