Worth a look. http://www.postuni.si/postuni/clanki/articles/vfpperformance/performance1.htm
Maybe you should look at using VFP direct table access but normalise the data to make record selection optimal (Rushmore). Also as I said earlier. What are the CA parameters? You can set a CA up to retrieve all or some data (Progressive) amongst many other settings. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: 09 July 2014 16:57 To: [email protected] Subject: Re: issue with dbf's If I do that and am dealing with a 30 box LAN, where all 30 users use the table at the same time, would it not slow performance? El 09/07/2014 12:52, Michael Oke, II escribió: > Why use an SQL statement at all? If he wants to see all the data, can't > you just display the table, which you have to open anyway? > > > On Wed, Jul 9, 2014 at 8:48 AM, Rafael Copquin <[email protected]> > wrote: > >> The way my client, an programmer from the 80's, wants his screens is, all >> the fields from the table to be shown at once in the one screen (no >> pageframes), so I am stuck with selecting all fields. >> >> I wonder what would happen if instead of selecting * I select all fields, >> but naming them one by one, like select field1,field2...fieldN from >> table.... >> >> I can avoid using CA's, but I would still need to use a SQL statement to >> bring a limited set of records like I mentioned >> >> > ----------------------------- > Michael Oke, II > [email protected] > 661-349-6221 > ----------------------------- > > > --- 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/[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.
