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: [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.
