I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
Your last question was about FoxPro 2.6. Is this, because the version makes a difference?
In the more recent VFPs, CDXes are much more stable and don't need rebuilds as often.
And there is no "CORRUPT CDX" command in VFP; this is often indicative of an unstable network, or an app where the clients turn off their machines.
On Wed, Nov 9, 2016 at 5:48 AM, Michael Madigan mmadi10699@yahoo.com wrote:
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
On 09/11/2016 11:18, Ted Roche wrote:
Your last question was about FoxPro 2.6. Is this, because the version makes a difference?
In the more recent VFPs, CDXes are much more stable and don't need rebuilds as often.
I've definitely found a difference between foxpro 2.6 and VFP indexes. Had a lot more problems with the 2.6 ones so was easy enough to set up an overnight indexer. We don't do this now the system has been upgraded to VFP but just run it every month or so to keep index bloat down.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
While we do have menu functionality that lets users rebuild the database including deleting all tags and re-indexing, I wouldn't say it is used by many of them in normal operations. It would only really be something we do to modify table structures during version upgrades or when customisations to the product are installed.
Life in a file server world compared to your data in a rdbms where you only get data through the api.
I haven't reindexed a table in my SQL servers in probably 10 years outside of freeing up wasted pages after a purge of a company's transaction data we sold off.
On Wed, Nov 9, 2016 at 5:18 AM, Ted Roche tedroche@gmail.com wrote:
Your last question was about FoxPro 2.6. Is this, because the version makes a difference?
In the more recent VFPs, CDXes are much more stable and don't need rebuilds as often.
And there is no "CORRUPT CDX" command in VFP; this is often indicative of an unstable network, or an app where the clients turn off their machines.
On Wed, Nov 9, 2016 at 5:48 AM, Michael Madigan mmadi10699@yahoo.com wrote:
I've been rebuilding indexes every night, does it really make a
difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.
--
rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, November 09, 2016 12:22 PM To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
Life in a file server world compared to your data in a rdbms where you only get data through the api.
I haven't reindexed a table in my SQL servers in probably 10 years outside of freeing up wasted pages after a purge of a company's transaction data we sold off.
On Wed, Nov 9, 2016 at 5:18 AM, Ted Roche tedroche@gmail.com wrote:
Richard Kaye wrote:
Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.
--
rk
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
Mike Copeland
Well, any computer file has potential for corruption. And there's lots and lots of settings for tuning. If you're using phpMyAdmin or similar, there's likely a "Settings"page.
My primary MariaDB system still under maintenance does a daily mysqldump to SQL, compressed, and shipped off to a warm standby system, where it's reconstituted, so the data is rebuilt nightly on the standby systems. The main system is dumped and rebuilt monthly or so.
On Wed, Nov 9, 2016 at 3:20 PM, Mike Copeland mike@ggisoft.com wrote:
Richard Kaye wrote:
Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.
--
rk
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
Mike Copeland
[excessive quoting removed by server]
On 2016-11-09 17:09, Ted Roche wrote:
Well, any computer file has potential for corruption. And there's lots and lots of settings for tuning. If you're using phpMyAdmin or similar, there's likely a "Settings"page.
My primary MariaDB system still under maintenance does a daily mysqldump to SQL, compressed, and shipped off to a warm standby system, where it's reconstituted, so the data is rebuilt nightly on the standby systems. The main system is dumped and rebuilt monthly or so.
Wow. Impressive. Makes me think about my setup, but as I said, there's been no signs of trouble, so I'm not wanting to do anything to a "not broken" system.
On 2016-11-09 18:06, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2016-11-09 17:09, Ted Roche wrote:
Well, any computer file has potential for corruption. And there's lots and lots of settings for tuning. If you're using phpMyAdmin or similar, there's likely a "Settings"page.
My primary MariaDB system still under maintenance does a daily mysqldump to SQL, compressed, and shipped off to a warm standby system, where it's reconstituted, so the data is rebuilt nightly on the standby systems. The main system is dumped and rebuilt monthly or so.
Wow. Impressive. Makes me think about my setup, but as I said, there's been no signs of trouble, so I'm not wanting to do anything to a "not broken" system.
Makes me think now of the H2Office water billing software I wrote back in 2007. Never heard from that customer since 2008 upgrade. (That's the problem with code that's rock solid--you don't get more business from that customer!! lol)
So I'm wondering how their performance is? I'm sure it's rock solid yet. Anything was better than the piece of shit DBF system they had prior to my completely new software. That's not a slam on DBFs; we all know they're great if engineering correctly in your design. However, this old shitty app gave a big clue when I saw this line in code: ON ERROR *
YES, I'M NOT KIDDING!!! LOL!!!!!!!
On 2016-11-09 15:20, Mike Copeland wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
--Mike
Thanks Mike!
I'm going on year 3 with a MariaDB server, dump the data for backup every night, never a problem.
Mike C
mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2016-11-09 15:20, Mike Copeland wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
--Mike
[excessive quoting removed by server]
On Nov 9, 2016, at 5:05 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
The ProFox archives are stored in MariaDB, and I’ve never even considered reindexing. IMO, that sounds like something is wrong with your t t hardware if you find it necessary to reindex constantly.
-- Ed Leafe
I don't get corruption, I just do it anyway.
----- Original Message ----- From: Ed Leafe ed@leafe.com To: ProFox Mailing List profox@leafe.com Sent: Wednesday, November 9, 2016 6:26 PM Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
On Nov 9, 2016, at 5:05 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
The ProFox archives are stored in MariaDB, and I’ve never even considered reindexing. IMO, that sounds like something is wrong with your t t hardware if you find it necessary to reindex constantly.
-- Ed Leafe
[excessive quoting removed by server]
:-)
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Michael Madigan Sent: 11 November 2016 07:42 To: ProFox Email List profox@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
I don't get corruption, I just do it anyway.
----- Original Message ----- From: Ed Leafe ed@leafe.com To: ProFox Mailing List profox@leafe.com Sent: Wednesday, November 9, 2016 6:26 PM Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
On Nov 9, 2016, at 5:05 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
I use MariaDB. Never been an issue. Customers never complained about speed, and no problems with tables. And that's over a period of 10+ years (with MySQL being used prior to MariaDB).
The ProFox archives are stored in MariaDB, and I’ve never even considered reindexing. IMO, that sounds like something is wrong with your t t hardware if you find it necessary to reindex constantly.
-- Ed Leafe
[excessive quoting removed by server]
_______________________________________________ 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/1877193576.1663588.1478850100735@mail... ** 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.
On Fri, Nov 11, 2016 at 2:41 AM, Michael Madigan mmadi10699@yahoo.com wrote:
I don't get corruption, I just do it anyway.
So, what was your question again?
My question was, "Is it a waste of time", but cutting down on CDX bloat means that it isn't a waste
----- Original Message ----- From: Ted Roche tedroche@gmail.com To: "profox@leafe.com" profox@leafe.com Sent: Friday, November 11, 2016 7:54 AM Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
On Fri, Nov 11, 2016 at 2:41 AM, Michael Madigan mmadi10699@yahoo.com wrote:
I don't get corruption, I just do it anyway.
So, what was your question again?
[excessive quoting removed by server]
I've never even encountered this CDX bloat thing, so for me I wouldn't bother really.
Well i beg to differ. Each year i create a warehouse app out of some txt files generated by a mf. They are in the +1gb class. Afterwards i delete the indexes and create new ones. New ones are about 1/3 smaller.
On Tue, Nov 22, 2016 at 1:25 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-11-18 04:18, Alan Bourke wrote:
I've never even encountered this CDX bloat thing, so for me I wouldn't bother really.
Ditto. I've seen FPT (memo) bloat, but never CDX bloat really.
[excessive quoting removed by server]
http://fox.wikis.com/wc.dll?Wiki~CDXBloat
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Jean Laeremans Sent: 22 November 2016 12:37 To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
Well i beg to differ. Each year i create a warehouse app out of some txt files generated by a mf. They are in the +1gb class. Afterwards i delete the indexes and create new ones. New ones are about 1/3 smaller.
On Tue, Nov 22, 2016 at 1:25 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-11-18 04:18, Alan Bourke wrote:
I've never even encountered this CDX bloat thing, so for me I wouldn't bother really.
Ditto. I've seen FPT (memo) bloat, but never CDX bloat really.
[excessive quoting removed by server]
On 2016-11-22 07:48, Paul Newton wrote:
Thanks for the link...very interesting!
On 2016-11-22 07:37, Jean Laeremans wrote:
Well i beg to differ. Each year i create a warehouse app out of some txt files generated by a mf. They are in the +1gb class. Afterwards i delete the indexes and create new ones. New ones are about 1/3 smaller.
What percentage of records were marked as delete? I'm 100% sure it had to do with that. I guess my experience is different because in my systems, the percentage of deleted records is very small.
Well...none.
On Wed, Nov 23, 2016 at 12:24 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2016-11-22 07:37, Jean Laeremans wrote:
Well i beg to differ. Each year i create a warehouse app out of some txt files generated by a mf. They are in the +1gb class. Afterwards i delete the indexes and create new ones. New ones are about 1/3 smaller.
What percentage of records were marked as delete? I'm 100% sure it had to do with that. I guess my experience is different because in my systems, the percentage of deleted records is very small.
[excessive quoting removed by server]
All a function on what columns of data are included in an index.
No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow.
Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column.
On Wed, Nov 9, 2016 at 2:20 PM, Mike Copeland mike@ggisoft.com wrote:
Richard Kaye wrote:
Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.
--
rk
Anyone have input on whether "checking the health of indexes...." is necessary or recommended in a MariaDB environment?
Mike Copeland
[excessive quoting removed by server]
On 2016-11-10 13:33, Stephen Russell wrote:
All a function on what columns of data are included in an index.
No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow.
Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column.
I've inherited a system (RIP, Jeff) where some tables HAS AN INDEX ON EVERY (or nearly every) FIELD. Holy freakin' moly.
Hahahahaha.
On Sat, Nov 12, 2016 at 7:42 AM mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2016-11-10 13:33, Stephen Russell wrote:
All a function on what columns of data are included in an index.
No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow.
Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column.
I've inherited a system (RIP, Jeff) where some tables HAS AN INDEX ON EVERY (or nearly every) FIELD. Holy freakin' moly.
[excessive quoting removed by server]
Ah - dang Stephen - don't B 2 cruel!
-K-
Sent from my iPhone
On Nov 12, 2016, at 1:30 PM, Stephen Russell srussell705@gmail.com wrote:
Hahahahaha.
On Sat, Nov 12, 2016 at 7:42 AM mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2016-11-10 13:33, Stephen Russell wrote: All a function on what columns of data are included in an index.
No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow.
Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column.
I've inherited a system (RIP, Jeff) where some tables HAS AN INDEX ON EVERY (or nearly every) FIELD. Holy freakin' moly.
[excessive quoting removed by server]
I have many indexes and so far, it doesn't seem to be any downside to it.
----- Original Message ----- From: "mbsoftwaresolutions@mbsoftwaresolutions.com" mbsoftwaresolutions@mbsoftwaresolutions.com To: ProFox Email List profox@leafe.com Sent: Saturday, November 12, 2016 8:42 AM Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
On 2016-11-10 13:33, Stephen Russell wrote:
All a function on what columns of data are included in an index.
No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow.
Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column.
I've inherited a system (RIP, Jeff) where some tables HAS AN INDEX ON EVERY (or nearly every) FIELD. Holy freakin' moly.
[excessive quoting removed by server]
Do you trust your operators? :)
On Wed, Nov 9, 2016 at 6:48 PM, Michael Madigan mmadi10699@yahoo.com wrote:
I've been rebuilding indexes every night, does it really make a difference? How many people rebuild each night and how many leave it alone?
each table randomly reindexed every 10 days
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 11:48, Michael Madigan a écrit :
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
Every night? I've gone years without reindexing DBF tables. Perhaps I'm weird but if the network and server are in a good, healthy shape then I think that the CDXs can be left alone under a moderate load.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, November 09, 2016 5:49 AM To: ProFox Email List Subject: Do you rebuild your indexes every night or do you leave them alone.
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
+1
John Weller 07976 393631 01380 723235 Sent from my iPhone
On 9 Nov 2016, at 15:25, Kevin J Cully kjcully@cherokeega.com wrote:
Every night? I've gone years without reindexing DBF tables. Perhaps I'm weird but if the network and server are in a good, healthy shape then I think that the CDXs can be left alone under a moderate load.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, November 09, 2016 5:49 AM To: ProFox Email List Subject: Do you rebuild your indexes every night or do you leave them alone.
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 16:25, Kevin J Cully a écrit :
Every night? I've gone years without reindexing DBF tables. Perhaps I'm weird but if the network and server are in a good, healthy shape then I think that the CDXs can be left alone under a moderate load.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, November 09, 2016 5:49 AM To: ProFox Email List Subject: Do you rebuild your indexes every night or do you leave them alone.
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
On Wed, Nov 9, 2016 at 10:52 AM, Thierry Nivelet tnivelet@foxincloud.com wrote:
I've seen CDX size divided by 10 after REINDEX
Wow, that's a lot. The table in question must have had a lot of updates.
yes, many updates and inserts
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 17:03, Ted Roche a écrit :
On Wed, Nov 9, 2016 at 10:52 AM, Thierry Nivelet tnivelet@foxincloud.com wrote:
I've seen CDX size divided by 10 after REINDEX
Wow, that's a lot. The table in question must have had a lot of updates.
[excessive quoting removed by server]
I thought I read somewhere that REINDEX does not reduce bloat and that to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 16:25, Kevin J Cully a écrit :
Every night? I've gone years without reindexing DBF tables. Perhaps I'm weird but if the network and server are in a good, healthy shape then I think that the CDXs can be left alone under a moderate load.
-Kevin
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, November 09, 2016 5:49 AM To: ProFox Email List Subject: Do you rebuild your indexes every night or do you leave them alone.
I've been rebuilding indexes every night, does it really make a difference?
How many people rebuild each night and how many leave it alone?
[excessive quoting removed by server]
Thierry -- are you using REINDEX or DELETE TAG ALL and rebuilding each manually?
On 2016-11-09 11:31, Paul Newton wrote:
I thought I read somewhere that REINDEX does not reduce bloat and that to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
FPD v2.6: Our computers are typically up 24 hours, they are programmed to send to my office any error reports, which I see first thing in the morning; and every 10 uses of a program that uses a particular database, a reindexing routing is run at execution.
John
On 11/09/2016 09:51 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Thierry -- are you using REINDEX or DELETE TAG ALL and rebuilding each manually?
On 2016-11-09 11:31, Paul Newton wrote:
I thought I read somewhere that REINDEX does not reduce bloat and that to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
[excessive quoting removed by server]
REINDEX is OK when index definitions are still here
DELETE TAG ALL and INDEX merely rewrites index definitions in DBF header and DBC
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
Le 09/11/2016 à 18:51, mbsoftwaresolutions@mbsoftwaresolutions.com a écrit :
Thierry -- are you using REINDEX or DELETE TAG ALL and rebuilding each manually?
On 2016-11-09 11:31, Paul Newton wrote:
I thought I read somewhere that REINDEX does not reduce bloat and that to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Thierry Nivelet Sent: 09 November 2016 15:53 To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet FoxInCloud Give your VFP app a second life in the cloud http://foxincloud.com/
[excessive quoting removed by server]
-
Alan Bourke -
Dave Crozier -
Ed Leafe -
Jean Laeremans -
John R. Sowden -
John Weller -
Kevin J Cully -
Kurt ＠ VR-FX -
Man-wai Chang -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Michael Madigan -
Mike Copeland -
Paul Newton -
Peter Cushing -
Richard Kaye -
Stephen Russell -
Ted Roche -
Thierry Nivelet