Javier, Thanks for your reply. I have indices on a number of columns but probably need to look at this more closely.
I have tried a few more things, and after resorting back to a 7.1 version which still worked properly with more than one user, I imported that version of the form, which uses exactly the same EEPs in the DBGrid, into the 7.5 version. I found that the old form worked fine, but the new version does not. I am currently stripping out various components on the new form to see if I can find which component is making the difference. Should I find out what causes this, (provided it is not too embarrassing) I may share this with others. Thanks for your time. Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Wednesday, 12 October 2005 9:27 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 John: Normally, the design of the database tends to have the most influence in the performance of any application; fast hardware can sometimes mask poor design and sometimes you can "brute force" increase the performance, but a good design is a always a better investment. A good, efficient design tends to perform well even on the lower end networks; likewise, bloated, redundant designs tend to bog down under heavy use. Time spent in the front end optimizing the database structure will definitely be a good investment in the long run. One thing that you might want to check is you indices; a properly designed index can speed things considerably. As an example, I had an application (4.5++) with an utility that updated about 20,000 records and it took just a couple of minutes; accidentally one of the indexes was deleted and the utility went from a couple of minutes to several hours...once the index was replaced the performance was restored. I have very complex, multi table forms ( 4-5 tables, over 300 Kb when unloaded) that work fairly efficiently; my menu forms are routinely over 600Kb when unloaded and work extremely fast. I tend to create indexes for every column that the end user will use for a selection; with inexpensive storage, the growth of the database files due to extra indices is not longer an issue for me. 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: Tuesday, October 11, 2005 3:09 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 Javier, I have tried a few options, including disconnecting all other users from the switch, however this made no difference. Next step was to try the RRBYW10 sample database. Doing an edi usi contacts worked fine, so I suspect that the problem may be more to do with my database than the network. The only problem I have is I am not sure what is wrong with it, as it works well with only one user connected, but that is about the limit. Why there is so much more network traffic with more than one user is the issue - with the sample database the peak is about 500 or so packets per second, with mine it is 8000. While I am using a fairly busy form, if it is fine with one user, what happens with two users connected that makes it so slow ? Any further thoughts as to what to try would be most welcome. Thank you. Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Saturday, 8 October 2005 1:12 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Network Performance V7.5 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 -- 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
