3 minutes for a 1G file on a good machine! How big is your database? What kind of network do you have?
When we switched from 7.6 to 8.0 we discovered that we really needed better computers and 1GB network cards. That is even more true using 9.5. -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 20 Jun 2013 17:30:04 -0500 Subject: [RBASE-L] - RE: some computers slow > Javier, > > I did your test and you may have found the problem. > One machine took three minutes for 1G file. > The bad machine would have taken 35 minutes. > I will talk to the boss and see what he says. > Thanks for the help. > > Jim > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Javier > Valencia > Sent: Thursday, June 20, 2013 5:08 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: some computers slow > > Jim, > > Before I get into the software, make sure you don't have hardware > issues, I.e. network cards or wiring. > Crete a large file, say 5 GB and copy it from every workstation to the > server and back and compare times. If you have hardware issues, you > will > see a big difference in transfer times. > > Javier, > > Javier Valencia, PE > O: 913-829-0888 > H: 913-397-9605 > C: 913-915-3137 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Jim > Belisle > Sent: Thursday, June 20, 2013 4:55 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: some computers slow > > I will check on these. > But would that not affect everyone? > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Bruce > A. > Chitiea > Sent: Thursday, June 20, 2013 4:41 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: some computers slow > > Jim: > > Also, is anyone running Carbonite or some other background/online > backup > program? > > Until disabled during working hours, Carbonite brings things to a > vicious crawl or full stop. > > You will see its process run in Task Manager. > > Bruce Chitiea > SafeSectors, Inc. > eCondoMetrics > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Jim > Belisle > Sent: Thursday, June 20, 2013 2:15 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: some computers slow > > Jan, > > Now I will show my lack on\f knowledge. > I have always had a problem figuring that out. > The configuration setting is TMP. > I have a hard time finding the files however. > > 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 > > > > > > > > > > > > > >
