Once you go that route, your remote users will love the speed. And there will be less conflicts for resources all round. A slow connection affects more than the remote user.
Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Monday, December 20, 2010 9:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Reports and Views with Where variables The only way processing on the Server is of any speed benefit is if you are going to use Terminal Services or its' equivlent. Any other method, the recordset comes to and is processed on the local machine. ----- Original Message ----- From: "Tom Frederick" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, December 20, 2010 10:36 AM Subject: [RBASE-L] - Reports and Views with Where variables I almost always use views for most reports to keep the data static while the report runs. Some reports are very large with multiple tables/views, a lot of columns, and heavy with text. On our in house LAN this is no big deal where even the most complicated reports are created in 15-20 seconds on most computers. Most of the reports are formatted for one individual so a 300 row view has 299 rows I really do not need. I have started to place 'WHERE (ZID = .vZID)' in some views which cuts the view down to the one row. ZID is simply an ID number. On our LAN I do not see any significant difference of 1 row vs. many row views. We are stepping into more wireless connections and I have followed the numerous discussions in the last several months on VPN and related topics. We have staff who work in the community and will do database entry through a laptop while away for their office. Speed and transmission time become an issue, so my question is: 'does single row vs. multi row views make much difference in wireless connections?' It would seem sending 299 rows of anything not needed simple slows things down. The related issue is processing on the server vs. the laptop. The server option seems obviously much quicker. We are moving from SBS 2003 to the 2010 version. Using v9.0 compiled, most recent update. I am bumping the current limits of my knowledge in this area, but that has been the story of my entire ride with R:Base. Just another problem to be solved. Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected] --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
