dotConnect for Salesforce offers client-side cache in the embedded database for optimizing performance of data retrieving. You may define which Salesforce.com or Database.com objects (tables) to cache and the cache parameters. If caching is enabled for a table, this table data will be stored in the cache when retrieved from Salesforce.com or Database.com. To learn more on managing cache, read the Working with Cache section.
The data can be selected with a SELECT statement, that is SQL-92 standard compliant. SELECT statements are executed in the following way:
The local query execution usually takes longer and uses more resources if the data is not cached already, so to optimize application performance it is better to use queries that can be translated to SOQL. To learn what queries can be translated to SOQL, read the SQL Translation topic.