skip to main content
Part 3: The 32-Bit Drivers : The Btrieve (Pervasive.SQL) Driver : Connection Option Descriptions : File Open Cache
  
File Open Cache
Attribute
FileOpenCache (FOC)
Purpose
The maximum number of used file handles to cache.
Valid Values
0 | x
where:
x
is a positive integer.
Behavior
If set to 0, no file open caching is performed.
If set to x, when a user opens and closes x tables, the tables are not actually closed. The driver keeps them open so that if another query uses one of these tables, the driver does not have to perform another open, which is expensive. The advantage of file open caching is improved performance. The disadvantage is that a user who tries to open the file exclusively may get a file locking conflict even though no one appears to have the file open.
Default
0 (No File Open Caching)
GUI Tab
Advanced tab