THE BEST PLACE TO KEEP A BACK END

[KUZZ]

I heard that it is better to keep the BE as close to a HDD root as possible, preferably in the root, because the deeper the BE is burried, the slower, a lot slower it gets. It that true, or is this a myth.

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[LNBruno]

The only time I've noticed any degradation in performance is when the network where the BE is located is getting a lot of traffic (and then everything slows down).

Nanoseconds! Who knew they could add up so fast?

< M!ke >

 

[psemianonymous]

Yes, this is listed on Tony Toews' (Access MVP) web site about database performance.

http://www.granite.ab.ca/access/performancefaq.htm

The "a lot slower" is probably untrue, but I don't know. I use UNC paths that are about 70 characters, so it's not a problem for me.