September 30, 2010
Stop Standing Still – Move Forward with c-treeACE Server
Note: c-treeACE became FairCom DB in October 2020.
c‑treeACE has been intentionally developed such that migration between different operating modes is mostly a matter of recompiling and re-linking an existing application. With the client/server model, additional features are available and should be considered when migrating from one of FairCom’s standalone operational models to the c‑treeACE Server. Additional details on migration to the client/server model are provided in “Migration Issues” of the c‑treeACE Programmer’s Reference Guide.
Why choose c‑treeACE Server technology over the standalone architecture for an existing application? Many applications that started out requiring only single user access may need to grow to support multi-user access. While the multiuser standalone model has filled that need for many years, it lacks features more robust applications need to support.
The c‑treeACE Server offers many advanced features not available in the standalone models due to the multithreaded core kernel technology.
- ANSI SQL
- Hot Backups
- Advanced Encryption
- Transaction Processing and Automatic Recovery
- Large Caches
- Partitioned Files
- Quiesce Activity
Bound Servers for Ease of Deployment
Did you know that the c‑treeACE Server engine can also be bound directly to your application? Much like the traditional standalone model you may already be familiar with, the bound server model is a perfect transition model. It is also very easy to deploy as it can be simply copied into your existing application installers.
The bound server model also offers incredible performance by avoiding all of the communication overhead of the application threads. Or, configure it to include communications logic for remote clients and/or monitoring for a truly flexible solution. True multithreaded server performance is directly available to your application.
In nearly every case, migrating an existing application to take advantage of the c‑treeACE Server is almost effortless, and can be done in less than a day. Check through the following items and you’ll be on your way in record time.
- Link your existing application to the c‑treeACE V9 multithreaded library, mtclient.lib.
- Copy or move your existing data and index files to the working directory of c‑treeACE. You could also consider theLOCAL_DIRECTORY configuration keyword to point c‑treeACE to your existing data location. Be aware that you will need to remove existing transaction log files as previous versions of these files are incompatible with c‑treeACE. Follow these steps to ensure a clean start with c‑treeACE.
- Rebuild indexes to take advantage of larger page sizes. Standalone models default to a 2048 byte index node size, while c‑treeACE Servers since V8.14 default to 8192 bytes. Increasing this allows more keys per node, as well as larger keys, that frequently arise when creating complex indexes via SQL.
- Switch your initialization to InitISAMXtd() and add the client user name and password to access the server. Use the Xtd()Function API calls that allow the user credentials and server name to be specified. You can include these in your standalone builds, as they are simply ignored in those models.
- Consider multithreading your application for enhanced scalability and performance.
- Access the power of c‑treeACE in your application immediately.
To take fullest advantage of server performance and features click here for recommended reading.
When you’re ready to start to consider the licensing impact of your migration to servers, be sure the appropriate business liaison on your side contacts a member of FairCom’s business development team. Licensing for the c‑treeACE server engine is different from the standalone licensing, and, like the technical migration, the licensing migration isn’t as difficult as it may seem at first blush. Our business development team works with your side to understand your unique application and market needs so, together, we can develop a model that works for you.
c‑treeACE Server technology offers a huge array of performance benefits and advanced features today’s applications demand. With FairCom’s commitment to ease of use and over 30 years of development know-how, we have intentionally included the ability to quickly migrate to our advanced database models. Contact your nearest FairCom office to see how our experienced engineering team can help you take advantage of these great features today.