Interesting article
Will study it
Tks
El 09/07/2014 13:01, Dave Crozier escribió:
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.
