QuickStart Development

[Richard Kreiss]

Mike,

I have been working in a Windows environment for many years.  I am used to having to throw a lot of hardware at performance issues.

As I indicated in a previous post, one client has a report that process just over 4,700 records.  The issue here is that each record can reference between 30 and 50,000 plus records using a lookup next to the order detail file.  The output is only 1 line for a csv file but when run directly on their old server, this took over 6 hours.  They are replacing the old server and I ran a test with this report and it runs in under 3 hours.  Since this report is run at least twice a week, that is a big boost in performance.

By the way, the office manager usually logs into the server using RDP and runs this output.  Running this over the network - if memory serves it would take just under 12 hours to complete.

Richard Kreiss


> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Mike Schwartz
> via Filepro-list
> Sent: Monday, June 6, 2016 1:34 PM
> To: filepro-list at lists.celestial.com
> Subject: RE: QuickStart Development
> 
> > Mark,
> >
> > You are correct in that there is no real speed benefit with today's
> hardware.
> > Ken has indicated this many time in the past.
> >
> > Richard
> 
>      I still have a couple of customers who require tokenization due to server
> speed and server RAM limitations.  They have over 100 customer service reps
> running a huge order entry input processing table and they have a web site that
> is continuously making tomcat calls to filePro request output processing-only
> tables that return invoice information and other data to their web-based
> customers.  The faster speed and much smaller code size of the tokenized tables
> is the only way that they can function.
> 
>     Occasionally when they are testing new code by running the PRC, their server
> (SCO Openserver 6, HP DL380s with 32-gigs RAM) will slow to a crawl or start
> issuing various lack of memory  messages.  And yes, I suppose One-Gate or
> getting a newer, faster server would help, but that's something they will only
> tackle if absolutely necessary.
> 
> Mike Schwartz
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 12047 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160607/d5cba632/attachment.bin>