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]
