Jim:
In our systems practice we always segregated mission-critical application
temporaries from general system temporary files, with two benefits:
1. Better performance (less fragmentation)
2. Easier to inspect and troubleshoot
I create a distinct and unique 'container' folder which sorts to the bottom
of a folder list:
D:\ZZZ
... inside of which I create folders as we like:
D:\ZZZ\DCAD
D:\ZZZ\EXCEL
D:\ZZZ\MONARCH
D:\ZZZ\RBASE
I've amended your code snippet below to show how mine might look:
.
SET VAR vChkFile = (CHKFILE('D:\ZZZ\RBASE'))
IF vChkFile <> 1 THEN
D:
MD D:\ZZZ\RBASE
ENDIF
SET SCRATCH D:\ZZZ\RBASE
.
ERASE D:\ZZZ\RBASE\*.$$$
.
Hope that's helpful
Bruce
SafeSectors, Inc.
eCondoMetrics
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Thursday, June 20, 2013 2:22 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: some computers slow
I found the scratch settings in the DAT file.
SET ERROR MESSAGE 2077 OFF
CLEAR VAR vChkFile
SET VAR vChkFile INTEGER = NULL
SET VAR vChkFile = (CHKFILE('D:\ZZZ\RBASE'))
IF vChkFile <> 1 THEN
MD D:\ZZZ
MD D:\ZZZ\RBASE
ENDIF
SET SCRATCH D:\ZZZ
SET ERROR MESSAGE 2262 OFF
SET ERROR MESSAGE 2926 OFF
SET ERROR MESSAGE 2077 OFF
ERASE C:\Temp\*.$$$
SET ERROR MESSAGE 2926 ON
SET ERROR MESSAGE 2262 ON
SET ERROR MESSAGE 2077 ON
When I am in the application, however I n\do not see any scratch files being
created in this location.
Jim
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen
Sent: Thursday, June 20, 2013 3:53 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: some computers slow
Where are your scratch files going?
-----Original Message-----
From: "Jim Belisle" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 20 Jun 2013 15:40:06 -0500
Subject: [RBASE-L] - RE: some computers slow
> Here is what is happening on this particular machine.
> 1) other programs are not slow so something is amiss in how RBASE is
> communicating with this machine.
> 2) Even in simple lookups RBASE goes into 'not responding' mode in the
> form caption and it is truly not responding.
> I know this because the task manager shows no CPU usage at all for the
> RBASE application.
> We are talking taking a minute (or more) to do a simple lookup that
> other machines are doing in seconds.
> This is the puzzling part. It is certainly machine related.
> The task manager is showing no other applications using any CPU except
> the task manager itself.
>
> Anyone have any other ideas?
> We are looking into seeing if there is a virus scan that is part of
> the problem.
>
> Jim
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Kenny
> Camp
> Sent: Thursday, June 20, 2013 3:12 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> A little more info for RBase programmers with little IT experience.
>
> Users and newbie IT guys often think that RBase has frozen or crashed
> because windows reports (in the caption of some forms) that RBase has
> "quit responding". Almost always this is incorrect, and some IT guys
> will kill RBase without thinking further, but by using the task
> manager you can see that RBase is working hard, but just hasn't
> communicated with Windows for a while. Other programs do this too,
not just RBase.
>
> But if your program is caught in an infinite loop, it will show a
> CPU%, but will never end.
>
> If someone kills a process that is in the middle of it's work, you can
> imagine the damage to the data that could result.
>
> Remember "Ready, aim, shoot!"
>
> Not "Ready, shoot, aim!"
>
> Kenny
>
>
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Kenny
> Camp
> Sent: Thursday, June 20, 2013 2:59 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> It's actually very interesting for geeks like me.
>
> For this analysis, ignore all processes that are just "loaded" and
> focus on the ones "running" (showing a CPU usage above 0%).
>
> Click on the CPU header to sort by CPU%. If things move to fast to
> read, resort by image name and scroll to see which are running and how
> much.
>
> It is normal for the system idle process to equal (100% - the rest of
> the processes ) for example my computer right now shows:
>
> System idle 96%
> Taskmgr.exe 2%
> outlook.exe 2%
> ---------------
> equals 100%
>
> When I quit typing the outlook goes to 0% and system idle goes to 98%.
> When Rbase is busy working, you can see how much of the processor CPU
> it uses (very interesting). When the work quits, RBase will still be
> loaded, but it is not taking any CPU% so CPU usage will drop to 0%.
>
> If other processes are using a % of the CPU consistently, I would
> google the image name and see what you can learn.
> Some processes come and go as they are called by other programs or
> services.
> Indexing and virus and malware scanners can grab a lot of resources,
> but better written programs wait in the background (0%) until they see
> idle time and jump in an take a %.
>
> There are a many good resources on the internet to describe what a
> process is, but there are many bad ones that try to trick you into
> loading unnecessary crapware.
>
> If you have one you are very concerned about and need help, you can
> email mme off list and I will research it for you.
>
> Kenny
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Jim
> Belisle
> Sent: Thursday, June 20, 2013 2:27 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> Kenny,
>
> The real question I have always had when looking at the task manager
> is what programs need to be running.
> I am not an IT man, just a RBASE man so I have no idea which ones
> should not be running.
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Kenny
> Camp
> Sent: Thursday, June 20, 2013 1:56 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> When one computer is slow and another is fast, I would assume
> something extra is running on the slow computer. Look at the task
> manager processes and see if something is running (check CPU usage).
> Make sure to check the box to see processes running from all users.
>
> Kenny
>
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Jim
> Belisle
> Sent: Thursday, June 20, 2013 1:35 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> On the scanning for viruses, would you be talking about the individual
> computers?
> If you are talking about the server that would affect all the
> computers.
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Kenny
> Camp
> Sent: Thursday, June 20, 2013 12:42 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - RE: some computers slow
>
> Could be the system indexing or scanning for viruses.
>
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Jim
> Belisle
> Sent: Thursday, June 20, 2013 12:32 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - some computers slow
>
>
>
> Here is the problem.
>
> We are using the newest version of 9.5 and we are running a compiled
> application.
>
> Each computer is set up so when starting the application, it looks at
> a timestamp file to see if I have made any changes to the application.
>
> If there have been changes, the code uploads the updates and then the
> session starts.
>
> The actual database is on the server.
>
>
>
> On some computers when opening forms or running reports, the session
> is super slow.
>
> At the same time, other computers can open the same form or run the
> same report and it is very quick.
>
>
>
> Most computers are running Windows 7 but some still run XP.
>
> Some computers are 64 bit and some 32 bit.
>
> Neither of the above seems to make a difference.
>
> If fact one of the 64 bit win 7 machines is the slowest.
>
>
>
> Can you folks give me some ideas as to what I should look for on the
> particular machines to care for the speed issues?
>
>
>
> James Belisle
>
>
>
> Making Information Systems People Friendly Since 1990
>
>
>
>
>
>
