How does that have anything to do with the price of tea in China? lol
It wasn't that an index was out of whack; it's that the attempt to fully
optimize caused VFP to unfortunately filter the table instead of give me
an inaccurate count of the cursor.
On 6/26/2020 11:06 AM, Man-wai Chang wrote:
Maybe your server should reindex all DBFs every night after office
hours! That's what an 10-year-old FoxPro/DOS MIS system I used to
maintain was doing.... :)
On Thu, Jun 25, 2020 at 10:33 AM MB Software Solutions, LLC
<[email protected]> wrote:
MYSTERY SOLVED! IT *WAS* THE DELETED INDEX THAT CAUSED THE CHANGE IN
BEHAVIOR! I dropped the index, re-ran with the code as it's been the
past 4 years, and it worked completely fine.
So much for my seeing if the DELETED() index helped. As I said...I
don't think any very small performance gain would be worth the
aggravation this caused. (Made me doubt other areas working for years
too....you know, the things nobody yet noticed or told you about?!?!?)
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[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.
