Karen,
There was a thread in August 2010 - I recall John Minyo commenting on this but I haven't managed to find his post. What I found at the time was as follows:- "....I recently had an issue with the amount of CPU time one particular database was using. This was due to the number of RB? files I had in the directory (all but one set being the database in use, the others being renamed superseded versions) - deleting these reduced CPU usage on a two CPU machine from a continuous 50% (i.e. essentially all of one CPU) to a minimal amount." At the time I used procmon to see what was happening and saw that RBase was 'looking at' all the RB? files in the directory even though they weren't connected. While you were presumably referring to the number of files in general, my experience then was that the number of database files had a major effect on performance. I tried adding a few redundant *.RX? files to a directory yesterday with 9.5 but it did not happen then, so perhaps something has changed. Maybe John Minyo can provide an update on how this works now. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, 31 May 2012 1:22 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed and # files No problem with this thread diverging a bit, but my original question was not about what files might be open and running at any one given time. In the past, people have indicated that the number of files sitting in the database directory had a bearing on speed. That if you had 4 database files and one startup file it would be faster than if you had those files plus a hundred extra files in the directory. My question was if it's different if the database is in its own directory. Karen In a message dated 5/30/2012 8:10:12 AM Central Daylight Time, [email protected] writes: We use the Microsoft Management Console to look at open files running from the network shared folder. Some files are open with read access, some are read/write access. We average about 500+ open files at a time on the network share. 50 of those are connections are to the .rb* files, while the rest are eeps, cmd, exe, etc. We now have more computers than ever and I am worried we are stressing the system to much.
