Performance problems when multiple users access files on NAS drives
Loading times increase drastically the more users access the file.
MM
shared this idea
1 comment
-
Mark Burns
commented
Of course it does!
Since the dawn of the JET database engine (written by Microsoft as A PART OF THE WINDOWS OS), JET (and now later the ACE Engine) database files have always transacted database reads and updates to the database file by reading and writing WHOLE HARD DRIVE DISK PAGES at a time. NAS storage methods are great, except where they make that impossible, simulating that behavior instead by sending the contents of whole disk pages across the network as a bunch of TCP/IP (or other network protocol) data packets.
This does work, but can NEVER be as efficient as the original design of reading and writing disk pages to a local hard drive. Ergo, it is slower when the data files are on the network.