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

[Nancy Palmquist]

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