Re: query difference

If you are talking about a Jet or ACE database engine DB... the defaults
with Access 2003 and earlier, and Access 2007, respectively, they are
file-server databases, with all the processing and manipulation done on the
user's machine, so both will bring across the LAN all the selected Records
(if the Records are selected on the basis of the Primary Key, or other
indexed Field, only the index will be brought across first, then only the
selected Records... but you are asking about _Fields_, so that is not an
issue here).

There is no Jet or ACE "server" running on the shared folder or "server" to
do any extraction or manipulation.

If you have linked tables in a server DB: MS or Sybase SQL Server, Oracle,
Informix, etc., then the extraction may be done at the server, thus reducing
traffic on the network. But, you will pay a price in complexity of
installation and maintenance of the server DB -- all of them need
"administration", which is to say "ongoing tender loving care". That is a
tradeoff only the developers and users can make -- do the benefits justify
the costs?

Larry Linson
Microsoft Office Access MVP

"bobh" <vulcaned@xxxxxxxxx> wrote in message
news:c12a4f6f-b615-4763-ab7f-a4fc3e7de6e1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

Is there a difference in preformance between the two;

TblNme has 36 fields across a record

a query that selects all fields and the report only uses 75% of the
fields, ie; Select TblNme.* where OffCde='123'

or

a query that selects the 27 fields used in the report
ie; Select TblNme.FieldNme, TblNme.FieldNme, etc.... where
OffCde='123'

In the first senerio does the query first bring down all the
data(including all the fields) and then select out the fields form the
criteria?
thanks
bobh.


.

Relevant Pages

  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to make your report run faster
    ... "WHERE SITE_ID IN depend on each query. ... after main report or same time? ... >> - The DB server is Oracle. ... > When you use Reports embedded in a subreport control and the ...
    (microsoft.public.access.reports)
  • Re: Dates in Report
    ... How about creating a new query that joins the MonthNums ... >started, ended, and the server name. ... >span they would like for the report. ... The query behind the report has a field that sums ...
    (microsoft.public.access.reports)
  • RE: Output Query Problem
    ... What is the total record count of the resulting Query? ... having a problem with my VBA code executing when the DB is on the server it ... does not output my query to create an excel file on the server. ... I would get the msgbox "no Data, no report" (an ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dates in Report
    ... >started, ended, and the server name. ... >span they would like for the report. ... The query behind the report has a field that sums ...
    (microsoft.public.access.reports)