Re: Aggregate string concatenation efficiency problem

OK. So far, what I am gathering is that you are performing an operation
that involves a query and also involves a string that is being
concatenated and that something is happening very slowly.

I hope I don't sound condescending here, but what is it that is
happening very slowly? The string concatenation operation? Or when you
run your original query?

Does this large string have anything to do with the original query? Or
is the string used in another operation and that operation is executing
very slowly?

The required information would be to explain exactly what is happening
slowly and what you are trying to accomplish - example: I need to run a
query to which generates a list of ... This query runs very slowly.

or

I need to run a query which generates of list of ..., and I am creating
a large concatenated string to be used as part of the Where clause in
this query. The string generation is very slow.

Right now the challenge is to get in to RDBMS-speak (speak database
language). Once we are both on the same page we can solve your problem.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Too Few Parameters Problem w/Query
    ... I am trying to run a concatenate function in a query and I'm having a ... Domain As String, _ ... ' Description: A generic "concatenation" routine. ... Dim strConcatenate As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Too Few Parameters Problem w/Query
    ... when I run the query it grinds for about an hour and then says there ... Domain As String, _ ... ' Description: A generic "concatenation" routine. ... Dim strConcatenate As String ...
    (microsoft.public.access.gettingstarted)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: Need help with Code Please!!!
    ... putting the query SQL itself in here maybe it will help you understand what I ... the actual string that gets built at the end of the SQ1 build process. ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ... Dim qd As QueryDef 'object ref to query item ...
    (microsoft.public.access.formscoding)