New in version 6.1.0: See the new features.

Server cache service example

This is a simple example of a server cache service use, these commands must be sent to the sql command or scodbc driver:

cache set synchronous = false;
cache add "C:\sql\business\employees" OPTION CFO_KEY_FILE and CFO_ALL_INDEX and CFO_INDEXES_ONLY;
cache add "C:\sql\business\products" OPTION CFO_KEY_FILE INDEX "by_price";
cache add "C:\sql\business\actdet" OPTION CFO_KEY_FILE INDEX "by_adate_officer_item", "Xheaderseq";
cache commit;
cache status;
cache wait;

---

RELATED TOPICS

Server cache service introduction

Server cache service SQL Queries