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.
================================================
