Jim, The first thing to know is if all your workstation are connecting at the speed they are supposed to connect; if you see differences between workstation it might indicate issues with the network that need to be addressed first. A while back I developed a standalone application that creates files on the fly of whatever size you want and loads and unloads to and from the network to the local workstation and times the process; I sent a version to several board members and I am sure I still have it on my computer. It has been very helpful to me in isolating workstations with issues which tend to be either a failing or improperly configures network card, bad wiring or router switch issues. One workstation in particular that had very slow connecting speed was discovered to have part of the wiring coming to it to be coiled over a fluorescent light and bad outlet connections.; once we corrected that situation the issue went away. Best regards, Javier Valencia, PE President cid:[email protected] Valencia Technology Group, LLC 14315 S. Twilight Ln. Suite #14 Olathe, Kansas 66062-4571 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected] Visit us at: <http://www.vtgonline.com/> http://www.vtgonline.com Confidentiality Notice This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic email or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately at 913-829-0888 or by reply email so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. GreenNoFrame From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, June 27, 2016 12:51 PM To: [email protected] Subject: RE: [RBASE-L] - speed in form coming up Javier, When we first started using the compiled application, we did put the forms and reports in the application and set it up as you mentioned. But we also wanted the flexibility you mentioned because I am constantly updating forms/reports or creating new forms and reports. So we changed and now bring forms and reports up as needed. I am not an IT person and we depend on an outside IT company. When you said, “depending on the network” what factors of the network would present this kind of slow processing? Going from 1 – 2 seconds to 8 seconds for a form to come up is a big difference. I also get a “not responding” statement quite often though it is really working. James Belisle Making Information Systems People Friendly Since 1990 cid:[email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Monday, June 27, 2016 12:42 PM To: [email protected] Subject: RE: [RBASE-L] - speed in form coming up Jim, As I understand it, the fastest approach would include compiling the forms/reports in the application and then install the application on every workstation and just have the database reside on the server. I choose to keep the forms and reports not included in the application and keep the application and database on the server. While the performance is not as good, it is plenty fast (depending on your network) and it gives me the ability to update forms/reports on the fly on a live database and the next time the user open the form/report, the new version is used…can’t beat the flexibility this approach allows. Best regards, Javier Valencia, PE President cid:[email protected] Valencia Technology Group, LLC 14315 S. Twilight Ln. Suite #14 Olathe, Kansas 66062-4571 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected] Visit us at: <http://www.vtgonline.com/> http://www.vtgonline.com Confidentiality Notice This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic email or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately at 913-829-0888 or by reply email so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. GreenNoFrame From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, June 27, 2016 12:12 PM To: [email protected] Subject: [RBASE-L] - speed in form coming up We use the last version of RBASE 9.5 and we use a compiled application drawing our data from the server. The forms and reports are not included in the compiled application. Many of our forms come up using the on key press forms that work great. Once we double click on the on key press form, the actual editing form comes up. If I use this process on my local drive, the editing form comes up quickly (1 – 2 seconds). When using the process on the server, it takes upwards of 8 seconds for the editing form to come up. I know including the forms and reports in the application is supposed to be faster but I did not think it would be that big a difference. Are there other areas I can look at or suggest to the IT company we use? James Belisle Making Information Systems People Friendly Since 1990 cid:[email protected] -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
-- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
