Viewing By Entry / Main
August 14, 2007
Slow data retrieval with CertPay
Q) When I retrieve data in CertPay using Peachtree, it takes a very long time to update information. What causes this and how can I fix it?
A) This is caused by a file locking issue in Peachtree. To prevent the issue from occurring, make sure that the company is closed on all workstations before attempting to retrieve data.
The issue was reproduced in the following test:
- Three computers were used - all were running Windows XP Professional and were members of a domain.
- Peachtree Quantum 2008 was installed.
- One of the computers was set up as a server for Quantum.
- The other two were set up to look in a shared folder on the server for the company data.
- All three computers had the test company open.
- On the server the employee list was displayed.
- On the first workstation the employee list was displayed and an employee was opened for editing.
- On the second workstation with CertPay installed the Default Employee information window was opened.
- When the Default Employee information window was not opened, retrieving data in CertPay did not slow down. Once it was opened updating data slowed to a crawl because certain files were locked.
- There may be other conditions that would cause undesired file locking, but this is one example.
Comments
Comments are not allowed for this entry.



