Welcome, Guest. Please Login.
05/25/25 at 13:07:15
News:
Home Help Search Login


Pages: 1
Send Topic Print
File Maintenance Functions (Read 3542 times)
julian
Browser
*


I love YaBB 1G -
SP1!

Posts: 26
File Maintenance Functions
08/01/06 at 05:17:41
 
I have a similar problem with two of the file maintenance functions I ran.
 
1.  I ran SM-J-D Consolidate Inventory Transactions.  We had transactions dating back to 2003 and I consolidated up to 1/1/2006.  My problem is that after doing that, my INVTXN_B file increased by a bit more than 25%.  Shocked
 
2.  I also ran SM-J-J Purge Closed Sales Orders.  It also increased both BKARINV, and BKARINVL.
 
I've started to look through INVTXN to see whats in there, but there are only a few records dating back to before 2006 still in there.  I may run a full comparison of the old file and the new one to see exactly what's different.
 
Anybody have any ideas?  Anybody run these programs succesfully?
 
I'm running 2004.1 right now.  I plan to be running EVO in a couple weeks; will that help this problem?
 
Thanks!!
 
Julian
Back to top
 
 
Email   IP Logged
julian
Browser
*


I love YaBB 1G -
SP1!

Posts: 26
Re: File Maintenance Functions
Reply #1 - 08/01/06 at 08:51:51
 
I've run some queries on INVTXN and here's the data.
 
before consolidate inventory transactions:
file size: 156MB
Code:
SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01' 

result: 204733
Code:
SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01' 

result: 78883
 
after consolidate inventory transactions:
file size: 216MB
Code:
SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE <= '2006-01-01' 

result: 5360
Code:
SELECT COUNT(MTIT_KEY) FROM "INVTXN_B" WHERE MTIT_DATE >= '2006-01-01' 

result: 78883 (same)
 
It does speed up the time it takes to run the first query, and that's all I'm really concerned with.  It sure is strange however...   ???
Back to top
 
 
Email   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: File Maintenance Functions
Reply #2 - 08/08/06 at 14:26:18
 
you need to use the Pervasive Rebuild utility, and Rebuild the INVTXN file, which will adjust the physical size due to the record consoldation.
 
don't forget to make a backup, prior to using the Rebuild utility.
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
julian
Browser
*


I love YaBB 1G -
SP1!

Posts: 26
Re: File Maintenance Functions
Reply #3 - 08/09/06 at 07:27:08
 
Nice.  That did the trick...  Thanks Dave!
 
 Grin
Back to top
 
 
Email   IP Logged
Pages: 1
Send Topic Print