At 14:06 2016-11-03, [email protected] wrote:
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.
????
I do not use reindex.
I decided to check. I found that I do the table pack before I
call the table's indexing routine. The indexing routines all had
delete tag all, but that is too late. I have added one to just
before the pack.
I had not caught this since my indexing runs fairly quickly.
Thank you.
Sincerely,
Gene Wirchenko
[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/f357a17db8fb186f0038f0bf43c0075f@mtlp000085
** 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.
