Message
From
28/11/2006 11:42:42
Mike Yearwood
Toronto, Ontario, Canada
Toronto, Ontario, Canada
To
27/11/2006 13:21:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172353
Message ID:
01172971
Views:
15
>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.
>
>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.