fP export time

[Don Coleman]

Ken:

We were able to perform the test you requested this AM, on the primary client used to run this export.  The other client we tested the export time on was unavailable this AM.  Scanning for a non-existent value (but meeting its assigned edit) on a non-indexed field scanned the entire file in 2:20 (two minutes twenty seconds, 610376 records).  We also ran the export again, this time adding the beginning & ending date on the extended selection screen, which normally has two search criteria values.  Normally, the client does not enter the date on the extended selection screen, but enters it via select processing.  The date selection is the only thing occurring in the select processing.  I did note I am not using lookup- to speed up the select processing, but can certainly add it.  

Anyways, today's export time with the beginning & ending dates added to the extended selection was 27 minutes, better than last weeks 37 minutes, but still extraordinarily long.  On her previous very low-powered work station, this export took 2-3 minutes.   

Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
(724) 349-6302
(412) 849-2589 (cell)

---------- Original Message ----------------------------------
From: Kenneth Brody <kenbrody at spamcop.net>
Date:  Fri, 08 Aug 2014 16:03:48 -0400

>On 8/8/2014 3:31 PM, Don Coleman wrote:
>> Bruce:
>>
>> The exact menu command line is:
>> \fp\rreport dmexcept -f Point_Click_Care -v askdate -s -u
>>
>> Point Click Care is the A/R application I export the data to.
>> In the fP Configuration Editor I have PFIXS=ON, so no -j menu flag necessary.
>[...]
>
>Since your previous post with the timings showed that the slowness was the 
>sort/select phase, it could be the "askdate" sort/select processing. 
>However, since you say it runs faster on the older systems, it's not likely 
>to be related to processing.
>
>I haven't seen an answer for my previous question about using dclerk to 
>search a non-indexed field for a value that doesn't exist, and comparing 
>timings across workstations.
>
>-- 
>Kenneth Brody
>
 




________________________________________________________________
Sent via the WebMail system at mail.dgcreact.com