Author Topic: Pricing updates slow with data on network  (Read 5881 times)

0 Members and 1 Guest are viewing this topic.

norman

  • Administrator
  • Sr. Member
  • *****
  • Posts: 272
    • View Profile
    • Zipzap Computers Limited
Pricing updates slow with data on network
« on: December 28, 2018, 01:29:47 pm »
If your data is stored on a network drive and you have a lot of customers and pricing systems then this may take some time. This is due to the fact that the network must be given time between each write for other computers and programs.

If you want to speed this process up then consider doing the process on a loacl drive instead.

How to do this -

1. Make a new directory on your local C: drive. As an example one called TESTDATA
2. Run TPN Invoicing and note the current data location. This appears on the top of the screen between square brackets e.g. [T:\]
3. Go into Utilities and BACKUP. Alter the destination to the new directory e.g. in my case C:\TESTDATA
4. Now go into Utilities and DATA PATH. Alter this to the new directory.
5. Go into Utilities and RESTORE DATA. Browse for the file BACKUP.ZIP in the directory you are using. Restore the data.
6. Do your pricing alterations. This will be a lot quicker. (Your original data is still in the original location). Check the price changes look OK.
7. Go into Utilities and BACKUP. You can save to your temporary directory again.
8. Go into Utilities and Data Path. Alter this back to the original directory e.g. in my case T:\
9. Go into Utilities and RESTORE. Browse for the file BACKUP.ZIP in the temporary directory. Restore this.

DO NOT ALLOW USERS TO WORK ON THE ORIGINAL DATA UNTIL YOU HAVE FINISHED. ALWAYS CONSIDER SAVING A BACKUP ELSEWHERE BEFORE YOU START SO THAT YOU CAN ALWAYS GO BACK TO IT IF THINGS GO WRONG.

All done.

Norman
 ;)
« Last Edit: December 28, 2018, 01:45:06 pm by norman »