Re: Aggregate string concatenation efficiency problem

On Jan 30, 12:29 pm, Rich P <rpng...@xxxxxxx> wrote:
Well, lets review what is going on to make sure I am straight on what is
happening:

1) The query runs fast in the Query Grid
2) The query runs slow in a Make Table query

If this is the case, then try this: make a copy of your query but
remove column5. Now run a make table query on this copy query. If the
make table query runs fast without column5, then we have narrowed it
down that column5 is the trouble maker.

If this is the case, then try creating a test query that only retrieves
the same data column5 retrieves. The problem may be in how you retrieve
the data for column5.

Rich

*** Sent via Developersdexhttp://www.developersdex.com***

Rich,

Exactly. Well now at least we're finally on the same page. Column5
has been the culprit from the beginning, that's what I was pointing
out in my first post. Column5 runs a function to calculate its value,
and that function is a sort of pseudo-aggregate function.

I did a make-table without Column5 just in case I was insane and to
make things totally clear, and as expected, it ran fine.

If this is the case, then try creating a test query that only retrieves
the same data column5 retrieves. The problem may be in how you retrieve
the data for column5.

I don't know what you mean here. I can create a query with only
'Column5' but I don't know why you are suggesting I do that.
.

Relevant Pages

  • Re: Aggregate string concatenation efficiency problem
    ... operation to run slow when you are trying to read Column5. ... Now all of the query data is in the temp table which I called tblX. ... equal to the amount of time it took to complete the make-table query. ...
    (comp.databases.ms-access)
  • Re: Aggregate string concatenation efficiency problem
    ...  The query runs slow in a Make Table query ... make table query runs fast without column5, ... fConcatChild() function has to be reevaluated, and as written, this ... static dbs as database ...
    (comp.databases.ms-access)
  • Re: Aggregate string concatenation efficiency problem
    ... does this query of only column5 run OK by itself? ... Public Function fConcatChild(strChildTable As String, ... Dim varConcat As Variant ...
    (comp.databases.ms-access)
  • Re: Aggregate string concatenation efficiency problem
    ... The query runs slow in a Make Table query ... make table query runs fast without column5, ... fConcatChild function to use a static database variable. ... static dbs as database ...
    (comp.databases.ms-access)
  • Re: Aggregate string concatenation efficiency problem
    ... The query runs fast in the Query Grid ... make table query runs fast without column5, ... then try creating a test query that only retrieves ... the same data column5 retrieves. ...
    (comp.databases.ms-access)