fP export time

[Bruce Easton]

Don - you said "from a standard fP menu".  So there is no "-i" or "-j" 
on the standard d/report line used for dpromenu then?  I'm just trying 
to make sure that an index issue is not involved (or difference in use 
of an index).

Bruce

On 8/8/14 12:40 PM, Don Coleman wrote:
> Bruce:
>
> Any or all users access the export function from a standard fP menu \fp\rreport filename.  No fP menu script involved.
>
> There is a select table used, asking & selecting begin and end dates, used by all users.
>
> Don Coleman
> Donald G. Coleman, Consultant
> 402 Andrew Circle
> Indiana, PA 15701
> (724) 349-6302
> (412) 849-2589 (cell)
>
> ---------- Original Message ----------------------------------
> From: Bruce Easton <bruce at stn.com>
> Date:  Fri, 08 Aug 2014 12:23:47 -0400
>
>> Don - what is the actual output request being run?  Is it a script?  Is
>> there an index and/or selection prc table involved in the selection
>> process?  Could there be a difference in how the export is called
>> between the PC scenarios you show below?
>>
>> Bruce
>>
>> On 8/8/14 11:57 AM, Don Coleman wrote:
>>> I have a long-time client who creates a monthly billing export.  Previously this export would take 2-3 minutes to create.  The user (Kerry) recently had her WINXP machine (export took 2-3 minutes to complete) replaced with a far more powerful WIN7 machine, but the export now takes 37 minutes to complete.  I also had their on-site I.T. person create the export from another user's machine (Pauline), and while on that machine it does take longer than the old WINXP machine, it is still faster than Kerry's new machine.  Does anyone have any thoughts on what could be causing this?  They use AVG Business Edition as their A/V, hosted on both the client and the server.  Disabling the AVG A/V on Kerry's new machine has no effect on the export time, 37 minutes (repeatable) with A/V enabled/disabled.  Their I.T. person sent me the basic hardware specs on each of the respective clients and server.
>>>
>>> fP v. 5.6.03 (Windows).  Contents of the .bat file are
>>> ECHO OFF
>>> TITLE=R.E.A.C.T. BAR-CODE SYSTEM
>>> SET PFNET=ON
>>> SET FILES=80
>>> SET PFDSK=z
>>> SET PFDATA=z:
>>> SET PFPROG=z:\REACT
>>> SET PFDIR=\REACT
>>> SET PFPRINTER=LJ4250
>>> SET PFLMHOST=aprcdc1.APRC.LAN
>>> SET PFTMP=C:\TEMP
>>> SET PFMENU=z:\REACT\FP\MENUS
>>> REM SET PFPOSTPRINT=C:\PRINTWIZ\PRINTWIZ.EXE C:\TEMP\HARDCOPY.TXT
>>> %PFPROG%\FP\p.exe react
>>> REM %PFPROG%\FP\p.exe
>>>
>>> C:\TEMP folder does exist.
>>>
>>> Kerry's Old PC:
>>> ============
>>> - Windows XP SP3
>>> - 32-bit OS
>>> - Intel Pentium Dual CPU E2140 @ 1.60 GHZ
>>> - 1.0 GB RAM
>>>
>>> Export took 2-3 minutes, max (I'm told)
>>>
>>>
>>>
>>> Kerry's New PC:
>>> =============
>>> - Windows 7 Professional SP1
>>> - 64-bit OS
>>> - Intel Core i5 4570 @ 3.20 GHZ
>>> - 8.0 GB RAM
>>>
>>> Export started at 9:25 AM
>>> 9:35 record selection began (first record selected)
>>> 10:00 record reading/selection ended
>>> 10:02 generating output completed (37 minutes)
>>>
>>>
>>>
>>> Pauline's PC:
>>> ==========
>>> - Windows 7 Ultimate SP1
>>> - 32-bit OS
>>> - Pentium Dual-Core E5400 @ 2.70 GHZ
>>> - 4.0 GB RAM
>>>
>>> Export started at 7:41AM
>>> 7:46 record selection began (first record selected)
>>> 7:55 record reading/selection ended
>>> 7:57 generating output completed (16 minutes)
>>>
>>>
>>>
>>> Server:
>>> ======
>>> - Windows Server 2008 R2 SP1
>>> - 64-bit OS
>>> - Intel Xeon E5503 @ 2.00 GHZ
>>> - 12.0 GB RAM
>>>
>>>
>>> Don Coleman
>>> Donald G. Coleman, Consultant
>>> 402 Andrew Circle
>>> Indiana, PA 15701
>>> (724) 349-6302
>>> (412) 849-2589 (cell)
>>>
>>>
>>>
>>>
>>> ________________________________________________________________
>>> Sent via the WebMail system at mail.dgcreact.com
>>>
>>>
>>>    
>>>                      
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>   
>
>
>
>
> ________________________________________________________________
> Sent via the WebMail system at mail.dgcreact.com
>
>
>   
>                     
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>