Schema cache Files


(system) #1
Assuming you mean Schema Cache, this creates a local copy of the DB schema. Each time a client starts, it must have a copy of the DB schema before it can execute any procedures. This is normally down loaded from the db, over the network. Creating the local cache on a
client should reduce network traffic, and speed the start up of a client. You will get an error message if the db schema changes, and the cache is not updated, but the client reverts to normal mode and gets its copy from the DB.

So the down side is a little extra maintenance if the schema changes (from a patch, or when you do an upgrade). Upside is potential reduced network traffic, and faster client start-up.

HTH.


/* ================================================================= */

Programmers, with their inbuilt sense of order and discipline, should really be running the world.

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada K2M 1T1 PEG Member 1998051404

Specialists in Progress software development since 1985