Slow issue with filepro on Windows 2003 / XP clients - Just Started

[Coleman]

---------- Original Message ----------------------------------
From: Nancy Palmquist <nlp at vss3.com>
Date:  Tue, 05 Jan 2010 15:35:06 -0500

>Guys and Gals,
>
>Filepro 5.0, Windows 2003 server, XP Clients
>
>****  NOTHING HAS CHANGED in the indexes or programming related to 
>database for months *****
>Customer does not know of any change on the OS or Network.  We tried it 
>from a computer with the virus stuff off, just to be sure that was not 
>the issue.
>
>Looking for a reason that filepro should start to take 4 to 30 seconds 
>to add a record to a file.  This behavior started yesterday. 
>
>The file has 3.0 million checks/charges, and has .5 million free records.
>
>First thing we did was run freechn on the file.
>
>The indexes have been rebuilt  twice today and finally rebuilt after 
>being removed first.
>(File has 5 absolutely required indexes, one index that is optional.  We 
>removed the optional one with no improvement.)
>
>The server has been rebooted.
>
>Processes that add records to this file, seem to get slower and slower 
>the more people are working with the check file.
>
>One person adds a record to this file in about 8 sec.  Two people and 
>both people seem to take as much as 30 sec to add a record to the same file.
>
>It goes downhill from there.
>
>Other processes that add records to other files do not seem to have any 
>issue.
>
>We have done everything we can think of to try to find out what is 
>dragging it down.
>
>I generate a log file and exactly when a record is added to the check 
>file is when I have jumps in 5 to 25 seconds in time.
>
>A routine that opens a file to a free record, loads some data and writes 
>the record.  A total of 4 lines of code.
>
>Any one have any suggestion, we are desperate to get the users working 
>again, at full speed.
>
>Nancy
>
>-- 
>Nancy Palmquist 		MOS & filePro Training Available
>Virtual Software Systems	Web Based Training and Consulting	
>PHONE: (412) 835-9417		   Web site:  http://www.vss3.com
>
>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list
>

Nancy:

I know you said you either checked the A/V or disabled it but was it confirmed from both the server & client side?  IOW, I've seen A/V updates wipe out config settings that told the A/V app. to exclude network drives on the client side.  Check on the server side to confirm the filePro folder is excluded as well.

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