Jim,
How many expressions do you have defined in the "variables" section of the form. It is very possible that is what is causing the slowness. John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, October 29, 2009 9:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow Bob, I appreciate the response. The form has a header and detail section based on two temp tables. The header has multiple popups, one with 3000 or so rows to choose from, but none of these are slow in populating. The header also has the fields associated to the variables since many of the fields populate automatically based on the customer ID. As I said none of these are slow. The detail section is what is slow. The model field is the field that brings up all the information (price etc) for the detail section. The popup has two fields that show, the model and the description, and the table it draws from has around 4500 rows. The popup is fast enough but when I choose (hit enter key) the model, that is what is slow. There are no form actions (I noticed what you stated about the dissolves when looking at some RRBYW14 forms) just 6 fields that populate. There is an EEP within the model field that is only used if we want to add a new product. In the table I get the information from, the model field is a primary key and I have two other fields indexed for sorting purposes. My only real question is do you see or can you think of anything else I could do from a design standpoint that may help? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of Castanaro, Bob Sent: Thursday, October 29, 2009 7:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow >>I log into the VPN then Remote to my computer in the office<< Yes that makes sense, I do it every day. Straight remote desktop is fairly fast, VPN to Remote Desktop a "little" slower. That being said, I took all form opening and closing behaviors off the forms I log into, because there are obviously multiple screen draws. For example, a form without any behavior may open within 1 second routinely. One with wipes or dissolves takes 10-15 seconds or more. Very frustrating, but not an R:Base problem. The dissolve type behaviors are the worst. Hope this helps someone! Bob C Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, October 28, 2009 6:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow I did not set this up but the IT people from a company that oversees our computers did. I understand it must be a combination of Remote and VPN. I log into the VPN then Remote to my computer in the office so the computer is tied up on that end. Does that make sense toanyone? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Wednesday, October 28, 2009 5:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow Jim, Some form controls require a lot more data (or slower, non-indexed data) to populate the drop-down or pop-up. A much better solution for remote access for R:BASE is something like logmein.com, or gotomypc.com, or even remote desktop, although these tie up a computer at the other end. Bill On Wed, Oct 28, 2009 at 6:19 PM, Jim Belisle <[email protected]> wrote: The strange thing is other forms do not have this problem. That is why I asked because I thought it might be something in the settings or the form itself I need to change. Maybe I need to bring up just one field in that particular table since the second field is rather large. I will play with it some more. Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, October 28, 2009 5:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow Bummer.... VPNs and file-server database do not mix. Same would happen if you were using Access, Filemaker, any non-client-server database. Performance is bad because the entire database has to be sent back and forth over your IP connection. We've had this discussion a few times on this forum, the last time it was asked by me because one of my biggest clients complains that they simply cannot work from home over their company's VPN. Karen Yes! From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, October 28, 2009 5:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: sloow You aren't using a VPN to access it, are you? Karen I have an order form in the latest 7.6 that runs very slow when I try using it from my remote location at my house. Are there settings either on my computer or within RBASE that will help overcome this? It happens with my detail lines that have auto popup &EEP fields. Another POPUP on the header does not have this problem.
