Welcome, Guest. Please Login.
05/05/24 at 10:50:31
News:
Home Help Search Login


Pages: 1
Send Topic Print
Archiving (Read 1034 times)
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Archiving
03/03/03 at 14:18:29
 
I have one that a client would dearly like to see:
 
Archive schemas for PO's and SO's to match the one for WO's.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Archiving
Reply #1 - 03/11/03 at 13:35:08
 
Anybody else have any opinion here?
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Archiving
Reply #2 - 03/11/03 at 14:06:26
 
Lorne, could you elucidate?
Back to top
 
 
Email   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Archiving
Reply #3 - 03/11/03 at 14:15:19
 
Holy cow Mike!  IS that the word of the day or what! Grin
 
Anyway, what I was suggesting was that for all PO and SO information, a set of schema tables the same as the exisiting ones for WOs be created to reduce the size of the active files and speed things up as well as giving the potential of storing those tables on large storage drives rather than the expensive SCSI drives in the server.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Archiving
Reply #4 - 03/11/03 at 16:09:04
 
The present setup for SOs (separate history files, purgeable main files) seems to give good access to historical queries and efficient/quick use of current files. How would your proposal to use the WO archive schema improve this?
Back to top
 
 
Email   IP Logged
Pages: 1
Send Topic Print