Discuss "Slow Concat Code" in the Microsoft Access forum.

Please see attached Sample,.

This may look like its fairly quick,.. but its the slow as hell,.. especially when cross referencing againts qty's already ordered. "not included in sample"

I have only attached a basic sample of the query with some data, on my full system this acts very much like a Dlookup would do on a continuous form. "if you were foolish enough to use one there"

Check out the module for the code

My Question is: Id there an alternate "Speedy way" to produce the same results as seen in the sample.

Thanks

AOG

Attached Files

db1.zip (13.7 KB, 7 views)

__________________
If i helped you, make me famous by clicking the

Do you absolutely need to use a variant data type? This data type produces extra overhead that could be causing some performance issues.

__________________
jmurrayhead
Did I help you out? Make me popular by clicking the icon!

If you found a post helpful, please click the button in the lower right-hand corner of the post.

Powered by ASP.Net

May also want to see if you can get this function working:
Very Fast String Concatenation

Another thought is to see if you can do some of this within the actual query.

Ive added the example of the very fast code,

I included & "-" & in the query so its easier to see what it's doing

Attached Files

db1_Backup.zip (14.4 KB, 2 views)

Did this work for you? It runs great on my machine.

Worked but didn't do what i wanted,.. might have made a mistake,.. see the latest upload above which shows the results ,.. thanks

After a little more testing,.. the original code is actully quite fast,.. my problem is the Tables are held on another Drive and the front end is on the desktop,.. connecting through the linked tables is causing the delay.

The example function AppendStrings in the link I provided accepts two parameters, with the second being an array. You would have to call this function after you created an array from the recordset values. I guess I misunderstood how you were doing this. I'm thinking there might be a way to do what you want from the query by itself...

I thought it was pretty fast when I ran it as well, but did still notice a performance hit when concatenating the strings.

@ JMH Thanks for your input,.. i guess its just a network issue,.. i'll leave this open a few days to see if anyone can come up with something,

"Please note we have looked at Performance Analyzer" and keeping the lbd open