WE had the same problem and tried all the tuning already mentioned. Our shipping department was ready to throw out the system because of the printing delays and the end of day shipment pressure.
What we ended up with was creating a terminal session on the Vanatage server itself and that reduced printing time significantly. The server is a dual quad core that runs about 8% utilization all day long.
Perhaps this would work for you also.
regards
jeffb
What we ended up with was creating a terminal session on the Vanatage server itself and that reduced printing time significantly. The server is a dual quad core that runs about 8% utilization all day long.
Perhaps this would work for you also.
regards
jeffb
--- In vantage@yahoogroups.com, "too_much_hg" <neil_willet@...> wrote:
>
> Michael,
>
> Thanks for the details !
>
> I have #3 set to 5 seconds.
>
> Seems like I can't do much about #6.
>
> But #10 caught my attention.
>
> Is there a place that I can reduce the 30 seconds ?
>
> How long does it take for this in your environment ?
>
> Thanks,
> Neil
>
> --- In vantage@yahoogroups.com, Michael Barry <mbarry@> wrote:
> >
> > Neil,
> >
> > The printing process flow can be described as follows:
> >
> > Where, Process, Action
> > --------------------------------------------------------------------------------------------------------------------------------
> > 1. Client, MfgSys, Print button clicked "report submitted" w/parameters
> > 2. Client, MfgSys, Write to SysAgentTask and SysAgentTaskParam tables
> > 3. Server, Task/Process Server, 10 sec delay(config) check for task in
> > above tables
> > 4. Server, Task/Process Server, Write task to "active" SysTask and
> > SysTaskParam tables
> > 5. Server, Task/Process Server, Create DB query using parameters +
> > primary key
> > 6. Server, Task/Process Server, Create XML document in appropriate ..
> > \MfgSysData\ directory
> > 7. Server, Task/Process Server, Write to SysRptLst when xml is completed
> > 8. Server, Task/Process Server, Update task in SysTask table and mark
> > History
> > 9. Server, Task/Process Server, Purge xml in ..\MfgSysData\.. not
> > printed or archived >15 min old
> > 10. Client, MfgSys, Check SysRptLst table for a print job for this
> > user every 30 sec
> > 11. Client, MfgSys, Read the xml doc on the server in the ..\MfgSysData
> > \...
> > 12. Client, MfgSys, Print or preview via Crystal runtime engine
> > 13. Client, MfgSys, Update SysRptLst Table as job is completed
> >
> > As you can see, there is plenty of room in this list for a 30 second
> > delay. In particular, step 6 can be quite burdensome if the report
> > outputs a large quantity of data and the output directory is on the
> > same set of spindles as the DB.
> >
> > Regards,
> >
> > Michael
> >
> > Michael Barry
> > Aspacia Systems Inc
> > 866.566.9600
> > 312.803.0730 fax
> > http://www.aspacia.com/
> >
> >
> > On May 21, 2009, at 10:09 AM, too_much_hg wrote:
> >
> > >
> > >
> > > Vic,
> > >
> > > On Job Travelers or Material Move Tags we see about the same thing.
> > >
> > > Anywhere from 30-90 seconds with most in the 40-60 second range.
> > >
> > > Is this what most people see on their systems ?
> > >
> > > I watch the CPU's on the App Server and it doesn't jump much nor
> > > does the RAM usage go up noticeably.
> > >
> > > What is the actual mechanism here ?
> > >
> > > a.User submits print preview.
> > > b.App Server gathers data from SQL ?
> > > c.App Server holds/crunches data ... or sends data to client ?
> > > d.Client generates Crystal View from data on App Server or Local ?
> > >
> > > I have plenty of Horse Power at the Server and Client, 100MB Network.
> > >
> > > Seems like things take their sweet old time.
> > >
> > > Neil
> > >
> > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> > > wrote:
> > > >
> > > > Neil,
> > > >
> > > > Explain "dog". When you print-preview a Job Traveler how long does
> > > it
> > > > take to display? 10 seconds? 60 seconds?
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf
> > > > Of too_much_hg
> > > > Sent: Wednesday, May 20, 2009 5:42 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: Printing Delay
> > > >
> > > > Thanks Vic,
> > > >
> > > > I setup a batch file and initially cleared out anything over 30
> > > days old
> > > > ... this reduced my old files by 1/2 = 1GB = several hundred
> > > thousand
> > > > files.
> > > >
> > > > I ran the script again set to 7 days and remove another 500MB.
> > > >
> > > > I left the script at 7 days and created a scheduled task to run it.
> > > >
> > > > Anybody have any other ideas on speeding up printing ?
> > > >
> > > > Crystal Reports seems to be a real DOG ! Any performance tips ?
> > > >
> > > > Thanks,
> > > > Neil
> > > >
> > > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> > > wrote:
> > > > >
> > > > > If Robert's suggestion doesn't work for archiving files, check
> > > out the
> > > > > "forfiles" NT command. I run a job scheduler on the NT server that
> > > > runs
> > > > > a batch file nightly to clear out files older than "X" days.
> > > > >
> > > > > Syntax is as follows. Just copy and paste this into a bat file.
> > > > >
> > > > > forfiles -p C:\mfgsysdata\Reports\ -s -m *.* -d -2 -c "cmd /c
> > > del /q
> > > > > @path"
> > > > >
> > > > > The -2 above indicates deletion age of the files. In this case I
> > > want
> > > > > to delete all files in that folder and all subfolders that are
> > > more
> > > > than
> > > > > 2 days old.
> > > > >
> > > > > I've found that no matter what I set in Vantage sometimes I have
> > > > > straggler files around. This circumvents Vantage and does what I
> > > tell
> > > > > it to.
> > > > >
> > > > > The only time I've possibly seen a performance hit with too many
> > > files
> > > > > is due to MRP logging. If you do the highest level of MRP
> > > logging I
> > > > can
> > > > > rack up 20K files in the ..\MANAGER folder within a week. That
> > > can't
> > > > be
> > > > > good.
> > > > >
> > > > >
> > > > > Vic
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > > Behalf
> > > > > Of too_much_hg
> > > > > Sent: Monday, May 18, 2009 6:31 PM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: [Vantage] Re: Printing Delay
> > > > >
> > > > > Thanks Vic.
> > > > >
> > > > > I found that setting and I had already set it to (2) seconds so
> > > > > apparently that isn't it.
> > > > >
> > > > > What about question #2 ? How exactly does the printing process
> > > work ?
> > > > >
> > > > > Does this scheduler scan the entire DRIVE:\mfgsysdata\Reports
> > > \Username
> > > > > folder structure trolling for files to print ?
> > > > >
> > > > > If so, maybe a regular cleaning would be in order, some of those
> > > > > Username Folders have thousands of files in there.
> > > > >
> > > > > Which files are safe to delete ?
> > > > >
> > > > > Thanks,
> > > > > Neil
> > > > >
> > > > > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@>
> > > wrote:
> > > > > >
> > > > > > Find this setting in:
> > > > > > System Management --> Utilities --> System Agent
> > > > > >
> > > > > > You will see the field for Processing Delay.
> > > > > >
> > > > > > I have mine at 3. If you have a halfway descent server you
> > > will be
> > > > > fine
> > > > > > with 3 to 5. Your files are stored under
> > > > c:\mfgsysdata\reports\{user}
> > > > > >
> > > > > > Help says:
> > > > > >
> > > > > > Processing Delay
> > > > > > The delay between the time the agent is started and the time its
> > > > > > schedules are processed. Use this field to regulate how long it
> > > > takes
> > > > > > the system agent to activate each task. If you have a fast
> > > server
> > > > that
> > > > > > can accommodate the traffic, enter a lower number; otherwise
> > > enter a
> > > > > > higher number. For example:
> > > > > > 10
> > > > > > 60
> > > > > >
> > > > > > Example: You set this field to 60 seconds. A user submits a
> > > report
> > > > > using
> > > > > > the Now schedule. It will take a maximum of 60 seconds for the
> > > > system
> > > > > > agent to pick up this task and run it.
> > > > > >
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> > > On
> > > > > Behalf
> > > > > > Of too_much_hg
> > > > > > Sent: Monday, May 18, 2009 4:33 PM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: [Vantage] Printing Delay
> > > > > >
> > > > > > We are experiencing a printing delay of anywhere from 30 to 60
> > > > > seconds.
> > > > > >
> > > > > > I remember a previous thread discussing a parameter "Processing
> > > > Delay"
> > > > > > related to printing but I could not find that setting.
> > > > > >
> > > > > > 1. Where exactly is this setting and what are the pros/cons of
> > > > > lowering
> > > > > > the value.
> > > > > >
> > > > > > 2. Are print files written to some folder somewhere that
> > > should be
> > > > > > purged periodically ? Could a large amount of files in this
> > > folder
> > > > > > cause larger delays ?
> > > > > >
> > > > > > TIA - Neil
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > > must
> > > > > > have already linked your email address to a yahoo id to enable
> > > > access.
> > > > > )
> > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > Builder
> > > > > > and Crystal Reports and other 'goodies', please goto:
> > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > (2) To search through old msg's goto:
> > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must
> > > > > have already linked your email address to a yahoo id to enable
> > > access.
> > > > )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder
> > > > > and Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > (2) To search through old msg's goto:
> > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must
> > > > have already linked your email address to a yahoo id to enable
> > > access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder
> > > > and Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>