The commands ADJUST TABLE CACHE PRIORITY and SET TABLE CACHE PRIORITY can be used to modify the priority of tables in a 4D Server. A general rule of thumb that can improve the performance of a server is to give large or infrequently used records a low priority and to give small or frequently used records a high priority.

ADJUST TABLE CACHE PRIORITY([Big_Records]; Cache priority low) ADJUST TABLE CACHE PRIORITY([Medium_Records]; Cache priority normal) ADJUST TABLE CACHE PRIORITY([Small_records]; Cache priority high)

Experimenting with cache priority can help improve server performance. However, these functions should still be used cautiously and often the automatic cache priority set by 4D will work fine.