FAQ's |
| |
|
| |
| |
1. What are the programming interfaces for CSQL ?
|
CSQL provides standard interfaces and proprietary interfaces
- JDBC – Standard Java Interface
- ODBC – Standard C Interface
- SQLAPI – Proprietary C++ interface to SQL engine
- CSQL – Interactive command line tool
It has all the features professional developers and architects need to build highly scalable, multi tier high performance and highly available systems.
|
| |
|
| |
| 2. What isolation levels does CSQL support ? |
| It supports READ_UNCOMMITTED, READ_COMMITTED, READ_REPEATABLE. |
| |
|
| |
| 3. How much RAM is required to use CSQL ? |
| Minimum RAM is 256 MB. It should be always greater than the size of the databases to get full performance benefit. Otherwise, OS may swap the pages. |
| |
|
| |
| 4. Can I replicate CSQL database ? |
Yes. CSQL Replication option provides data replication at multiple granular levels (database, table, records). It can be used to provide high availability and load balancing to CSQL MMDB.Visit Replicator FAQ for more information.
|
| |
|
| |
| 5. Is there any limit on database size ? |
The word length of the processor limits the database size. On 32 bit systems it is 4 GB(2^32) and for 64 bit systems it is 2^64 bytes.
|
| |
|
| |
| 6. Will the data be lost in case of power failure ? |
| No transactions are lost in case of any failure. CSQL uses write ahead redo logging to recover the database to the last consistent point before it crashed. |
| |
|
| |
| 7. Does CSQL support Triggers and Stored Procedures ? |
| No. It does not support. |
| |
|
| |
| 8. How scalable is CSQL with multi core and multi processor machines? |
| CSQL uses lock free data structures for storage and index structures, thereby reduces the contention drastically exploting higher utilization of CPU cycles in SMP systems. |
| |
|
| |
