Should I use JISAM or Veryant's c-treeRTG?

Question:

What are the basic differences between JISAM and c-treeRTG? What are the guidelines for choosing between them?

Answer:

Here are the benefits of each:

Veryant JISAM

isCOBOL Evolve supplies a high capacity, client/server, indexed ISAM file system called Veryant JISAM.

JISAM is written entirely in Java so it runs anywhere, even on a mobile phone.

Utility provided for basic file management
Utility provided for one-step migration of data files from other COBOL vendor's indexed files.
ODBC Driver for Windows
Maximum file size: 9+ exabytes (EB) (over 9 million terabytes)
Maximum number of keys: no limit
Maximum number of records: no limit
Maximum key length: 255 bytes
Maximum number of segments per key: 16
Maximum record length: 2 GB

Currently JISAM has the following limitations: transactions and compression are not supported
variable length records is not supported, the maximum record size is always used.

Veryant's c-treeRTG

A Client/Server product, it includes its own server (instead of using isCOBOL's application server)
Full Transaction Support
ODBC Driver for Windows
Supports Live Backup
Memory file support
Includes several feature-rich management utilities including Graphical tool for SQL access of your indexed data
Utility provided for one-step migration of data files from Vision.
Maximum file size: 16,000,000 terabytes (16 Exabytes)
Maximum number of keys: no limit
Maximum number of records: no limit
Maximum key length: no limit
Maximum number of segments per key: no limit
Maximum fixed record length: 65,535 bytes
Maximum variable record length: 2 GB
Compression: supported

The basic guideline is to use JISAM for smaller numbers of users (100 or fewer), or light data access, and use c-treeRTG for larger numbers of users or if you want to take advantage of the extra features of c-treeRTG