Message
From
27/11/2006 13:21:44
To
24/11/2006 20:46:37
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:
01172721
Views:
17
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.
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?
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.
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?