FAQ's |
| |
|
| |
| |
1. For which DBMS platform, caching is supported ?
|
For all existing commercial and open source databases, which provides standard ODBC library. This includes mostly all the leading databases. We have tested it with MySQL, Postgres, Sybase and Oracle. It should work seamlessly with other databases. If your face any issues, post in forums for guidance.
|
| |
|
| |
| 2. What is updateable cache ? |
| Most the existing caching solutions available in the market are read only caches. But CSQL Cache provides updateable cache, which shall be updated either in the cache or directly in the target database. |
| |
|
| |
| 3. What is Bi-directional cache ? |
| Syncing the Cache and the target database automatically without manual intervention for any changes either in cache or target database. CSQL Cache is bi-directional, which provides more flexibility for solution architects to accommodate CSQL caching in their architecture. |
| |
|
| |
| 4. Should the application manage the cache locality ? |
No. CSQL Cache has pass through mechanism, which allows the application to use only one single unified data source. CSQL takes care of routing queries and modification statement on non-cached tables to target database.
|
| |
|
| |
| 5. What is operation consistent cache ? |
When any database operation happens on cache, the same happens on the target database too. This makes sure that the cache and target database tables are in sync and provide the highest level of consistency for transactions.
|
| |
|
| |
| 6. Are cached tables recoverable in case of system crash/power failure ? |
| Yes. During recovery they are automatically retrieved from the target database during the CSQL server boot up. |
| |
|
| |
| 7. Can I use CSQL cache if some operations in the transaction involve join operation on cached and non-cached table ? |
| Yes. You can use it. There will not be any performance benefit for this query. Performance benefit will be seen only for operations, which involves only cache tables. |
| |
|
| |
| 8. If cache server goes down, will the application be able to access original tables? |
| Yes. Application tranparently fail over to target database and transactions continue to execute on target database directly. |
| |
|
| |
