Re: Calling functions from queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MacDermott (macdermott_at_NoSpam.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 15:26:40 -0400

My best advice would be to try it out and see.
Some functions run pretty quickly, others take longer.
Today's processor speeds are such that what used to be significant
performance hits are often barely noticable.

If you're calling these functions from a query, I don't know how you'd
spread the big string back out over the 8 columns without another major
bunch of function calls...

There's often a lot that can be done with query optimization, but a lot of
that is already done internally by Access (Jet), and it's usually pretty
specific to the functions in question...

    - Turtle

"ABL" <ablnews@newsguy.com> wrote in message
news:cgfv4i02iua@news1.newsguy.com...
> I have a query that has calculated fields and joins in it. I am
> wondering what kind of performance hit I might expect if I have to call
> functions 8 times(!) per row returned.
>
> 6 of these calls are to two functions (3 each) with different values.
> All 8 columns are consecutive. Would it be quicker to call one big
> function and return the "8 columns" in one big string (I am not using
> header rows, and these calculations are read only, so I don't need to
> change them)?
>
> Any suggestions for increasing performance are welcome.
>
> I am using A2K.
>
> Thanks,
> Alden
>
> Plese reply only to the newsgroup. This email address is seldom checked
> and is used to catch unsolicited email.

Relevant Pages

  • Calling functions from queries
    ... I have a query that has calculated fields and joins in it. ... wondering what kind of performance hit I might expect if I have to call ... and is used to catch unsolicited email. ...
    (microsoft.public.access.formscoding)
  • Re: Calling functions from queries
    ... If you find that running the query with all the function calls takes too ... > I have a query that has calculated fields and joins in it. ... > wondering what kind of performance hit I might expect if I have to call ... > and is used to catch unsolicited email. ...
    (microsoft.public.access.formscoding)
  • Re: Testing performance on a form
    ... Thanks Jeanette, but I already tried the query way and it also took the query ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... because I don't want to code all my calculated fields only to find out at ...
    (microsoft.public.access.forms)
  • Re: Same problem - different angle
    ... I have the following saved query which consists of 5 ... FROM tblBatches INNER JOIN (tblClusters INNER JOIN ((tblAdmin INNER ... One of the calculated fields concats some string ... I have this SQL statement I'm feeding to the OpenRecordset ...
    (comp.databases.ms-access)
  • Re: Best place to input data
    ... A form's view (single form, continuous form, datasheet) does not ... base a form on the query. ... You can also add expressions to the control source of unbound text boxes on ... now I want to add calculated fields to my data ...
    (microsoft.public.access.gettingstarted)