[sambar] Creating dB Caches and Deploying DBMS

[Michael Cook]

I am seeking the collective wisdom on the pros and cons of deploying database directories and caches.   One way would be to place all database tables in one directory, and create one system DNS that points to them, and create one Sambar dbms cache.  I'm in a situation where the connection caches for the specific users/database are the same across components, i.e. same ODBC driver (dBase), db Tables (dBase), Single Thread = true, Trace SQL = false, etc.  So the directory structure in this situation would be:   docs/     db/table1        table2        tableA        tableB   The other way would be to place tables from one dbms app. into separate directories and setting up multiple system DNS and multiple Sambar caches that point to each directory.  In this case the directory structure is:   docs/      db1/          table1          table2      db2/          tableA          tableB   Thoughts?   Thanks   Mike ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/