>Ok, lets talk about the Lock contention issue with views in a DBC.
>
>After reading this:
>
http://fox.wikis.com/wc.dll?Wiki~CreatingDBCForViews>
>People are saying that when a user access a view (e.g. Requery() ), the DBC is locked.
I thought it was just the view definition record(s). Just long enough to grab the SQL statement. Enough users and/or enough queries and you will get contention.
>
>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?
It does.