SqlClient.CacheBufferSize Property

SqlClient CacheBufferSize Property

Nemiro.Data.dll

File cache (File) memory buffer size (Kb). Default value is 2048 Kb (2 Mb).

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

public long CacheBufferSize { get; set; }

public long CacheBufferSize { get; set; }

Public Property CacheBufferSize As Long 
	Get 
	Set

Public Property CacheBufferSize As Long 
	Get 
	Set

Property Value

Type: Int64

Remarks

The buffer is used only if the property CacheType value has File.

You can use configuration file for this setting.

XML

Copy to Clipboard Print

<appSettings> 
  <clear /> 
  <!--Cache type--> 
  <add key="NeData:Sql:CacheType" value="File" /> 
  <!--Cache storage--> 
  <add key="NeData:Sql:CachePath" value="C:\cache\MyApplication" /> 
  <!--Memory buffer size 50 Mb (50 Mb * (1 Mb = 1024 Kb) = 51 200 Kb)--> 
  <add key="NeData:Sql:CacheBufferSize" value="51200" /> 
</appSettings>

<appSettings> 
  <clear /> 
  <!--Cache type--> 
  <add key="NeData:Sql:CacheType" value="File" /> 
  <!--Cache storage--> 
  <add key="NeData:Sql:CachePath" value="C:\cache\MyApplication" /> 
  <!--Memory buffer size 50 Mb (50 Mb * (1 Mb = 1024 Kb) = 51 200 Kb)--> 
  <add key="NeData:Sql:CacheBufferSize" value="51200" /> 
</appSettings>

Examples

C++

Copy to Clipboard Print

using (SqlClient client = new SqlClient())
{
  client.CacheDuration = 1200; // 20 minutes * 60 seconds = 1 200 seconds
  client.CacheType = CachingType.File;
  // memory buffer size - 100 Mb
  client.CacheBufferSize = 102400;
  // build query
  client.CommandText = "SELECT * FROM users";
  // execution query 
  var table = client.GetTable();
  // output
  Console.WriteLine("Rows: {0}", table.Rows.Count);
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
  Console.WriteLine("From cache: {0}", client.LastQueryResultsFromCache);
}

using (SqlClient client = new SqlClient())
{
  client.CacheDuration = 1200; // 20 minutes * 60 seconds = 1 200 seconds
  client.CacheType = CachingType.File;
  // memory buffer size - 100 Mb
  client.CacheBufferSize = 102400;
  // build query
  client.CommandText = "SELECT * FROM users";
  // execution query 
  var table = client.GetTable();
  // output
  Console.WriteLine("Rows: {0}", table.Rows.Count);
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime);
  Console.WriteLine("From cache: {0}", client.LastQueryResultsFromCache);
}

Using client As New SqlClient()
  client.CacheDuration = 1200 ' 20 minutes * 60 seconds = 1 200 seconds
  client.CacheType = CachingType.File
  ' memory buffer size - 100 Mb
  client.CacheBufferSize = 102400 
  ' build query
  client.CommandText = "SELECT * FROM users" 
  ' execution query 
  Dim table As DataTable = client.GetTable()
  ' output
  Console.WriteLine("Rows: {0}", table.Rows.Count)
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime)
  Console.WriteLine("From cache: {0}", client.LastQueryResultsFromCache)
End Using

Using client As New SqlClient()
  client.CacheDuration = 1200 ' 20 minutes * 60 seconds = 1 200 seconds
  client.CacheType = CachingType.File
  ' memory buffer size - 100 Mb
  client.CacheBufferSize = 102400 
  ' build query
  client.CommandText = "SELECT * FROM users" 
  ' execution query 
  Dim table As DataTable = client.GetTable()
  ' output
  Console.WriteLine("Rows: {0}", table.Rows.Count)
  Console.WriteLine("Query execution time: {0}", client.LastQueryTime)
  Console.WriteLine("From cache: {0}", client.LastQueryResultsFromCache)
End Using