The delay time in a networking environment, depends directly on the following factors:
- The speed of the Network connection. Wireless/Wire/Optical all differ in connection speed (i.e. Optical being the fastest will always give best results, Wireless will give the absolute worst results).
- The speed of the HDD of the PC that hosts the main / shared database file. It helps if this PC has a very fast hard drive and hard drive control er (i.e. SATA standard will be faster than IDE or EIDE).
- The speed of the PC that hosts the main / shared database file. It is a big delay problem if this PC goes into a power saving mode / screen saver mode or hibernation after being inactive for a certain amount of time and has to be woken up by the network card before it can start sharing the database upon every data request. So it helps a great deal if in the "Power Saving" settings on that PC the options are set to "ALWAYS ON".
- The Networking method/device/equipment speed. There certainly are routers on the market that give different performance results, so it helps to get a more professional router versus the more economic home use routers.
Also in our most current version of the software (or ver.2.29 and up), in setup, you can disable the "Auto Complete" option, and the software will be searching a lot less within the database, so that will speed up the run-time of the software.
Also, please keep in mind, in unbiased testing of many PC magazines, it was proven that Windows Vista was the absolute worst performer, regarding speed in a local area network environment. Perhaps that is why the Microsoft corporation scrapped this operating system faster than any other before in their history and completely replaced it with a new operating system Windows 7. So, if you are operating Windows Vista, switching back to any previous Windows or perhaps even Windows 7, will give you more satisfactory results.
And we cannot stress the Windows Vista problem enough. We experienced it in our own office as well, first hand, as soon as we switched from Vista to Windows 7 (or even if you switch back to XP) there is a difference in network data rate, right away, a difference in hundreds of kilobytes (from bytes and kilobytes of data transfer per second you will go to megabytes of data transfer per second). And it is not even a problem of measuring a simple data transfer, because the Vista acts ridiculously at times, some times randomly it may be an excellent data transfer on the network and you may think it is perfect in every way and there is no way there is a problem and then again randomly it drops to just a few bytes per second of data transfer rate.
Thank you,