SQLCache

SQLCache Specific Command Level Configuration Tasks

The "TTL", "Provider", "Data Source", "Username", "Password", "Database" and "Command" are Specific Command Level SQLCache Parameters.

These parameters are edited either by double clicking on the entry, or by selecting its properties.

Specific SQL Command Configuration Parameters are as follows:

Provider
When connecting to Microsoft's SQL server there are two options, SQLOLEDB and MSDASQL.

Microsoft recommend SQLOLEDB when connecting to SQL Server 2000 and MSDASQL for previous versions of SQL Server.

Generally, any OLE DB compliant provider can be used with SQLCache.

Data Source
When the Provider used is MSDASQL the DSN should be the name of the System DSN used to connect to the database server. If SQLOLEDB is used the DSN entry should be the name of the database server.
Tip: Create a DSN to your database using, as its name, the name of the database server (for example, sqlserver.internal.com). In this way both SQLOLEDB and MSDASQL can be used.

Username
This is the username used by the client to connect to the database.

Password
This is the password used by the client to connect to the database.

Database
This is the name of the database to connect to.

Time to Live(TTL)
This is the value, in seconds, that you want to cache the data on the accelerated host. After this time period has elapsed the data is refreshed.

Command
This is the specific command that you want to tune.

 


2002. SQLCache.com