ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Archiving
http://www.istechforum.com/YaBB.pl?num=1046722709

Message started by aricon on 03/03/03 at 14:18:29

Title: Archiving
Post by aricon on 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.

Title: Re: Archiving
Post by aricon on 03/11/03 at 13:35:08

Anybody else have any opinion here?

Title: Re: Archiving
Post by Mike_Habich on 03/11/03 at 14:06:26

Lorne, could you elucidate?

Title: Re: Archiving
Post by aricon on 03/11/03 at 14:15:19

Holy cow Mike! IS that the word of the day or what! ;D

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.

Title: Re: Archiving
Post by Mike_Habich on 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?