Alan Bourke wrote on 2014-12-24:

> 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,

In my particular case, this is an in house support tool. It is doing a

search across two memo fields for user entered words.

I have made changes which have reduced the searches to a few seconds instead

of minutes. The forms that would open these tables have been changed to only

open them when retrieving data, then later opened when writing data. The

search form also will not leave the tables open. When two techs initiate a

search, it will get slow again.

A web service will eliminate the slow speed caused by the network Christof

explained perfectly.

Tracy Pearson

PowerChurch Software

_______________________________________________

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/000001d01f91$90883930$b198ab90$@powerchurch.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.