When using Instant Invoice 2007 in a network, the performance is slow. What can I do ?

In a network, you should expect the network computers to perform slower than the server or host computer where the database folder is located. As a guide, you can expect the following performance :

TEST SYSTEM
– Database Size : 9000 plus invoice records
– Server/ Host computer : Intel Celeron 2.2Ghz / 736MB RAM / Windows XP
– Workstation : Intel Core 2 Duo, 1.8Ghz/ 2GB RAM/ Windows Vista
– Network : Server connected by Ethernet cable to the router. Workstation tested on wireless G (wireless) and Cabled (Wired)

PERFORMANCE TEST RESULTS
Opening database
Local : 2-3 secs
Network (wired) : 2-3 secs
Network (wireless) : 3-6 secs

Switch between invoices and quotations :
Local : 0-1 secs
Network (wired) : 0-1 secs
Network (wireless) : 1-2 secs

Quick Find :
local : 1-2 secs
Network (wired) : 1-2 secs
Network (wireless) : 1-5 secs

Power Find :
Local : 7-8 secs
Network (wired) : 7-8 secs
Network (wireless) : 12-13 secs

Running Outstanding Invoice Listing report
Local : 2-3 secs
Network (wired) : 3-4 secs
Network (wireless) : 6-7 secs

If performance on your network environment is very slow, a variety of factors may cause this. You need to adopt a systematic troubleshooting procedure to determine the cause of the problem. Try the following being sure to test the performance between each step to find out the root cause :

– Reduce the number of documents that are shown by default to 10 or less. Avoid displaying 100 documents in the listing. Click the menu option Tools | Options | General. Change the setting to 10 or less. Showing a lot of document will affect performance for daily task. Instead when you need to view past documents, click the Find button.

– Check your network install. Ensure that you have installed on a network correctly. The program should be installed on the local hard disk (C Drive). Only the database should be hosted on a network shared folder.

Hence if you have 3 workstations using the program. You need to install the program 3 times to its own hard disk. Do not install the program to a network share and share it to the other workstations.

– Disable any 3rd party firewall or anti-virus programs. Some of these programs have been known to significantly affect network performance. Right click its icon at the right side of the Windows taskbar and close the program. Do not disable the Windows firewall. Test only the 3rd party programs running in the background. Some users have reported significant performance boost when disabling certain 3rd party firewall or anti-virus program and switching to another vendors product.

– Try repairing the database. Sitting at the server or host computer, get the other network users to exit the program. Now click the menu option Database | Backup and backup the database. Now repair it with the menu option Database | Pack/ Repair. Now get the network users to start the program, open the database and test the performance again.

– If using a wireless or WIFI connection, check the signal strength on your computer. Use your mobile phone and go near the computer one at a time and check that you have a nice strong signal of 5 bars. Or you can download an app called “WIFI Analyzer” on your smartphone to check if you have a weak signal or a lot of interference from neighbours WIFI.

If there is a lot of interference, you can change your router to another channel or if you have a poor signal, you should ask your IT Tech to add a WIFI range extender nearer to your workstations.  Try connecting the server and workstation with a cable to the router/switch and repeat the performance test again.

– Try moving the database to another computer. Have the workstations open the database on the new PC then test the performance again.