Database Performace - local vs. mapped local

[rheide]

Hello All,
I have read a lot on the "performance threads" but I haven't really seen anyone discuss this.

We have a database that is split up FE/BE. While I am designing the application on my computer, I have all the tables linked directly to the local C drive. Everything works super fast this way.

The clients computers are set up so the tables are linked to their z drive (which is mapped to the server).

When I am ready to test the application, I map my z drive to my computer's C Drive (then link the database tables to my z drive). When I do this, the performance is terrible. For example, when I link straight to the C drive, a form may take 1 second to open. When I switch to using the z drive, it takes over a minute to open.

Can anyone explain what is happening to cause this delay?

Thanks,
Randy

 

[rpadams]

Try the old DOS subst command

I don't know how you are "mapping" the z-drive to your local c-drive. I develop networked programs on my local computer by using the old DOS subst command to make a local directory mimic the network drive. For example, in a batch (.BAT) file I run the following:
subst z: c:\localdir
and then use z: in the path for the Access backend link. "Localdir" is the subdirectory on my C-drive where I hold the backend mdb with the tables. I can't detect any difference in speed using the "Z" drive or the "C" drive -- both are really snappy.

You could also run the Subst command from the command prompt (Start)=>Run etc.

 

[rheide]

RPadams,
This is a great testing "trick". This will help with the speed on my local computer. Thanks a bunch!!

-R