Charles,
Further to comments/suggestions from others 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. I used process monitor (procmon.exe) on an XP machine to see what was happening with rbase.exe - it showed the files being 'used/looked at' by R:Base - this may help with your issue. I presume you have had a look at the network utilization with Task Manager ? Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, 5 August 2010 8:41 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Slow database Charles, Do you have hundreds or thousands of files in the current folder? R:BASE 9.0 may have a threshhold for the number of files it looks through to build panels like the "Command Files" group in the Database Explorer. I deleted 1000 obsolete and unnecessary files from a folder that had 2400 files in it, and suddenly a pokey workstation was snappy. Bill On Wed, Aug 4, 2010 at 4:30 PM, Mike Byerley <[email protected]> wrote: I have one machine (my own) that when Vipre AV is installed brings RBase to its knees. I changed all Vipre settings to disable anything that I could think would effect Network performance and wasn't successful. I remember Javier saying he had similar issues, but worked them out. Nontheless, you might look in that direction, unless it is system wide and not just a couple of boxes. ----- Original Message ----- From: "Albert Berry" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, August 04, 2010 4:22 PM Subject: [RBASE-L] - Re: Slow database Charles, it sounds to me as if you have network problems rather than trouble with the database. Have your network guru do some transfer tests to find the weak link. Albert Charles Parks wrote: The database is back to being slow today. I have tried ManOpt On and Off. Rebuilding the database Verifying the view definition Reloading the database Is there a way to speed it up? *From:* [email protected] [m
