FWIW: I manage files this way:
c:\rbti\ - program files
c:\temp\ - all temporary filed
d:\ - dedicated data drive
d:\rbms\ - root for all rbase data constructs
d:\rbms\<database>\ - root for individual databases
..\code\ - all code (.rmd) files
..\db\ - <database>.RX1 - <database>.RX4 ONLY
..\gway\ - all gateway import sets (Excel, CSV)
..\outputs\ - all temporary outputs (print files, etc)
..\unload\ - for quick local backups
May seem complicated at first, but all folders can be accessed with " ..\" from any point at the R> prompt. Only the C:\temp folder gets constipated.
Cheers!
Bruce
-------- Original Message --------
Subject: [RBASE-L] - Speed and # files
From: [email protected]
Date: Tue, May 29, 2012 9:32 am
To: [email protected] (RBASE-L Mailing List)
I've seen it mentioned several times on this list that database speed is affected by the number of files in the database subdirectory. I'm not sure if anyone would know the answer to this, but what if the database is located in a separate directory? RBase would be run from the program directory which could have many many files, connect to the database in another directory ....
Karen
