ISTech Support Forum - to archive WOs or to purge? that is the question

Welcome, Guest. Please Login.

	05/09/25 at 16:08:42 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›

Pages: 1

to archive WOs or to purge? that is the question (Read 1765 times)

Laura D. Oliver Active Member Posts: 985 Gender:	to archive WOs or to purge? that is the question 06/18/12 at 07:15:42 I archived about 18,000 work orders on Saturday, but WO-A etc, is still slow. I had expected to see a dramatic increase in recall/search/ Will I see a faster WO-A if I purge the workorders. tag: make DBA faster, SM-J-B. SM-J-E
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: to archive WOs or to purge? that is the quest Reply #1 - 06/18/12 at 07:26:06 You have to reindex your Work Order tables. UT-A NZINDEX.RUN If you dont have it buy it it is worth every penny. Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Laura D. Oliver

Active Member

Posts: 985
Gender: female

Re: to archive WOs or to purge? that is the quest
Reply #2 - 06/18/12 at 07:45:19

Thanks Kelloggs,
I did a search and found what Lynn said on a previous thread: "UT-A program NZINDEX (Classic) or NZINDEX.RUN (Evo) is a $49.95 add-on that can save list(s) of files to reindex together and provide a report upon completion of which files were reindexed and which were open and therefore skipped, and how much disk space was recovered"

Would it be in vain to buy and run NZINDEX.RUN if I am going to end up purging the workorders anyway?
Also what else would NZINDEX.RUN help with? Why else do people use it?

Blessings,
Laura

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: to archive WOs or to purge? that is the quest
Reply #3 - 06/18/12 at 07:52:43

DBA/EVO comes with a free re-index utility but you have to reindex each table at a time.
The NZINDEX.RUN utility will allow you to reindex all of them.

You can purge, delete records, but it will not increase the speed of your system until you reindex your tables.

You should reindex your tables at least twice a year anyways.

It is part of your "Database Maintenance Best practices"

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Laura D. Oliver Active Member Posts: 985 Gender:	Re: to archive WOs or to purge? that is the quest Reply #4 - 06/18/12 at 08:20:05 Thanks, I will be buying this today. I hope it is not to complicated. I guess I would have thought that PURGE would have an effect.....silly me....
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: to archive WOs or to purge? that is the quest Reply #5 - 06/18/12 at 08:51:33 Please remember: Backup your tables. DBA/EVO can not be use during the process. Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Laura D. Oliver Active Member Posts: 985 Gender:	Re: to archive WOs or to purge? that is the quest Reply #6 - 06/18/12 at 09:12:34 " Backup your tables" Am, I correct to assume that this happens when I send a copy of DBAMFG to a thumb drive? Or do I have to do something special?
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: to archive WOs or to purge? that is the quest Reply #7 - 06/18/12 at 09:19:45 You are correct Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›