Bruce, What would you put in your startup flle, rbase.dat? Which folder would you like to be in when you issue the CONNECT dbname command? Mike
--- On Tue, 5/29/12, Bruce Chitiea <[email protected]> wrote: From: Bruce Chitiea <[email protected]> Subject: [RBASE-L] - RE: Speed and # files To: "RBASE-L Mailing List" <[email protected]> Date: Tuesday, May 29, 2012, 3:28 PM 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

