Ok, lets talk about the Lock contention issue with views in a DBC.
After reading this:
http://fox.wikis.com/wc.dll?Wiki~CreatingDBCForViewsPeople are saying that when a user access a view (e.g. Requery() ), the DBC is locked.
If this is true, then this explains why our 40 user site is experiencing terrible performance on a gigiabit network!
Has anyone else looked into this?
If everyone had their own local DBC that contained view definitions, would this resolve the contention issue?