General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL's 100% faster when tables are EXCLUSIVE
I just ran tests on SQL's I'm running and I noticed when the tables are used exclusively the SQL's run about twiice as fast as when shared. Anyone else notice this? Maybe it's well documented but I was unaware of it. Is VFP checking for changes when the data is shared? If so, that would appear to contradict a recent answer in Advisor to Nick's tip for ensuring unique values.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only