Paul
Good suggestions but these offices are out of state and my network is down.
One office says the form gets slower as the day goes on, even if they restart
Rbase
after lunch.
I sent them 4 command files that basically run the form like our last 4
updates.
The main difference I am not testing is Temp table compared to regular table.
What I do is Delete rows from the Temp or regular table,
get the rows for the last invoice from the Hist table.
Insert that into a Temp table or regular table (depending of version),
change the date to today, Edit using Form, let the user add or make changes,
then Append or insert into the Hist table.
Also one version used a View to do part of this.
The only other chances are the location of the Scratch, never across the
network.
Thanks,
Marc
----- Original Message -----
From: paul
To: RBASE-L Mailing List
Sent: Sunday, November 16, 2008 10:20 PM
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
I have had employees say the same thing. Sometimes right and wrong. Restore
the older form from a backup and run a routine before and after the form runs
and capture the time. I install a var timer start as the form is called and
launches and displayed. I then compare the numbers with the other form (newer)
and also a form that runs from a temp table. Run the form with AVG off and
also active. Try with different computers and see if the same results are
found. I have found computers to be blame on several occasions and it had
nothing to do with Virus or RBase. I often test and tune on a local laptop and
then watch the outcome. I have a table that only grabs the computers and watch
the login and trap some application times. I also have left some of these time
var to be seen by the users so if they feel the system is slowing down they can
monitor it themselves.
I am surprised how often it is the employee and something other than AVG and
RBase about 9 times out of 10 it is the OS or something network ie:
packets, wiring (a fluorescent light moved) loose RJ-45. I am not say that it
is not AVG but I have found more employees with good intentions running
something that is just not so nice.
Run a check on each computer and KISS. I use RRBYW15 or 14 and try it from
there and see/watch the outcome. I have made copies and ran the timer code on
them and then I look at my work.
Paul
I would bore the RBase List with my stories but I remember the weird and
strange things that users have done. IE: Kicking the BNC-T connections and
playing with it for one(that was a while back and ages me) Just for one.
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MDRD
Sent: Sunday, November 16, 2008 10:22 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
Thanks Paul
I am just trying to see why a few users say this one form is slower on my
last update.
The C:\Temp for the Scratch files is different and I use a Temp Table for
this form now
instead of a regular table. So, this way my best guess.
Marc
----- Original Message -----
From: paul
To: RBASE-L Mailing List
Sent: Sunday, November 16, 2008 8:09 PM
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
I would believe that AVG would exclude any Windows system environment tmp /
temp folder that you or Windows has set. But if in fear include in the
exception screen in AVG. My fear would be the possible hole left open for
other hacks/attacks. I belong to a different Virus Software Utility users
group so I cannot offer much help on AVG. It might be a better question for
the AVG user group on how AVG handles the Windows System Environment Settings.
Mostly you would check on .$$$ and see how they are handled instead of just
adding the Dir/Folder.
I would also go back and check the information regarding mapping RBase
files. I think you will find best not to map and simply use the address. I
have 10+ active users on a Linux Server and they all access the rb* files by
address and run local exe's.
Just my .02
Paul
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MDRD
Sent: Sunday, November 16, 2008 7:26 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
HI
Should the Scratch file location be added to the exclude list?
This app has them set to C:\Temp would Scratch TMP be better?
Also, should you include the Mapped drive letter?
Thanks
Marc
----- Original Message -----
From: Bill Downall
To: RBASE-L Mailing List
Sent: Thursday, November 13, 2008 7:09 PM
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
Marc,
I don't know AVG. But most virus programs allow you to "exclude" files by
creating a list with wildcards. If all your R:BASE databases are on one
particular drive, and there are no other files on that drive that could contain
viruses on that drive, I suppose you could exclude a drive letter.
Bill
On Thu, Nov 13, 2008 at 7:57 PM, MDRD <[EMAIL PROTECTED]> wrote:
Bill
I assume we should include the mapped drive letter too?
Thanks
Marc
----- Original Message -----
From: Bill Downall
To: RBASE-L Mailing List
Sent: Thursday, November 13, 2008 5:39 PM
Subject: [RBASE-L] - Re: Could AVG 8 be slowing down RBase
Marc,
Be sure that you exclude all database files (*.RB1, *.RB2, *.RB3,
*.RB4, *.RX1, *.RX2, *.RX3, and *.RX4) from scanning.
Bill
On Thu, Nov 13, 2008 at 6:16 PM, MDRD <[EMAIL PROTECTED]> wrote:
Hi
Two offices that ran my latest 7.5 update said some forms are much
slower.
Both are using AVG 8 and I read that they had a problem flagging some
Windows files as malware.
Could that be causing the problem?
I know I need to update them to 8.0 but I am trying to get all my users
on the same page then make the jump early spring.
Thanks
Marc
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.2/1785 - Release Date:
11/13/2008 9:12 AM
--------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.3/1786 - Release Date:
11/13/2008 6:01 PM
