dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteConnectionStringBuilder Class / CacheSize Property

In This Topic
CacheSize Property
In This Topic
Gets or sets the maximum number of database disk pages that SQLite will hold in memory at once.
Syntax
'Declaration
 
Public Property CacheSize As Integer
 

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.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

SQLiteConnectionStringBuilder Class
SQLiteConnectionStringBuilder Members

 

 

© 2008 - 2025 Devart. All Rights Reserved.

Send Feedback