CacheSize Property

In This Topic

Gets or sets the maximum number of database disk pages that SQLite will hold in memory at once.

Syntax

Visual Basic
C#

'Declaration
 
Public Property CacheSize As Integer

public int CacheSize {get; set;}

Property Value

The maximum number of database disk pages.

Remarks

Each page uses about 1.5 kilobytes of memory. The default cache size is 2000. If you are doing UPDATEs or DELETEs that change many rows of a database and you do not mind if SQLite uses more memory, you can increase the cache size for a possible speed improvement.

Reference

SQLiteConnectionStringBuilder Class
SQLiteConnectionStringBuilder Members

Send Feedback