On 2016-11-03 14:24, Gene Wirchenko wrote:

> I have a routine that packs and reindexes all of the tables. I

> have not needed anything more involved.

>

> I do see some memo bloat. I have a table that stores

> configuration data. When packed, the .fpt is 1280 bytes. I see from

> the latest sent to me that it is up to 5,205,248 bytes. That is

> bigger than the source code.

Would the PACK do a reindex automatically? According to VFP Help (also

here:

https://msdn.microsoft.com/en-us/subscriptions/downloads/t2704cs4(v=vs.80).aspx ): "If the current table has one or more indexes open, PACK rebuilds the index files."

So your reindex, Gene, must be the EXPLICIT kind of reindex akin to

Stonefield Database Toolkit or your own explicit INDEX Field TAG MyOrder

commands. Otherwise, if you're just doing REINDEX, sounds to me like

you're doing it twice. In fact, if you're running your own reindex, you

may as well do a DELETE TAG ALL beforehand to avoid the double-work.

????

_______________________________________________

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/0239ac85aa726fbeeeb2cebb17c52ac8@mbsoftwaresolutions.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.