John: The other thing to check is that all network cards are working properly, under some conditions, a bad NIC will slow down the entire network. You can try looking at the packet transmission statistics to see if you can detect a trend, such as a workstation with a lot of NAKs requiring constant retransmissions. Network cards are inexpensive enough that when one is suspect, we just replace it. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of John Docherty Sent: Friday, October 07, 2005 7:00 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 Javier, Thanks for that. Yesterday I tried changing all the NICS from autosense to 100 full duplex, (as suggested by our hardware supplier) but that did not fix the problem. (Although I realise now that I didn't check the most important one - the one on the fileserver.) I did find one PC which had a rather different NIC which performed very slowly with a fixed speed set, however even when that PC was turned off my Rbase issues continued. I have tried various things so far, and must say that it is hard to arrive at a definite conclusion as to what causes this, as on one occasion, after I had everyone logoff and start again, I managed to get 'normal' performance for a while. If I get some time this weekend I may carry out some more tests. In regard to Razzak's suggestion re the Form compression I did try stripping the form back to the bare minimum yesterday, as I thought that the form 'size' may be an issue, but that had no effect. (Something I forgot to mention earlier - unfortunately this is only my spare time 'occupation' - I am really meant to be getting a tender finished - the issue is that we use my Rbase application to prepare it.) I will let you know if I make any more progress - thanks for your suggestions. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Saturday, October 08, 2005 12:43 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 John: There was a discussion a while back on the "other" List on the settings of the network card. Under Configure>Advance<Link Speed it was recommended that the speed setting should be set to 100 Mbps/Full Duplex; however, when I changed the Link Speed to that speed on client's network (Novell), the workstations slowed down to a crawl, setting the Link Speed to Auto Detect increased the speed dramatically. The conclusion is that this setting is very dependent on the router/switch hardware that you have; you might try setting it both ways and see if it makes a difference. I have heard that with some of the older hardware, if a single station is set to 10 Mbps then all the other connections will default to this lower speed which is OK for one workstation/session but very slow for more that one concurrent session. Just a thought... Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of John Docherty Sent: Friday, October 07, 2005 1:40 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 Razzak & Claudine, Thanks for your replies - compression was ON, so I have turned that off. I will see what effect that has when I get back to work on Monday (or earlier). Is there anything that Rbase does when more than one user connects to a database, that may cause the significant increase in network activity ? The network switch is only 100MB/s. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Saturday, October 08, 2005 2:08 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 At 06:48 AM 10/7/2005, John Docherty wrote: >... so I can only assume that the issue relates to RBase V7.5 >(and maybe Forms in particular ...) John, Using R:BASE 7.5 for Windows, how are your forms saved? Are they saved with the default settings of "Use Compression"? To find out the default setting: 01. Start RBG75 02. Database Explorer | Settings | Form Designer... To save the form without compression, make sure that option is un-checked. Once un-checked, make sure to open and then save all forms in Form Designer, if previously saved as compressed. Try this option and see if it helps in your specific situation. Very Best R:egards, Razzak. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/123 - Release Date: 6/10/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/123 - Release Date: 6/10/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 7/10/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 7/10/2005
