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:profox-bounces@leafe.com] On Behalf Of Christof

> Wollenhaupt

> Sent: Friday, December 19, 2014 8:36 AM

> To: profox@leafe.com

> 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: ProFox@leafe.com

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/1419432446.3277882.206461829.1A46F464@webmail.messagingengine.com

** 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.