Help with speeding up a string replace on a large file.

[Shawn Grover]

We have a case where we have 30+ instances of text in an RTF document that need to be replaced with specific database values.  The routine we have does work, but it's pretty slow.  In one case, we have a 1+ meg file, that we need to do the 30 replacements on via the REPLACENOCASE function.  This file is taking approx 3-5 minutes to open.  We've explored using REREPLACE instead, but are not seeing any noticable speed improvement.

The algorithm we have is something like so:

1. read file into a memory variable via the CFFile tag with action=""> 2. Loop through our elements to replace
3.    do an replace on the file in memory for the current element
4. End loop
5. Write the new file out to a temporary file (which we manage through another process).

We've used the GetTickCount function to narrow down exactly where the delay is, and it's in the loop - not on the read and write commands.

I'm sure there's a better way to do this - we're looking for a sub 10 second response time, if possible.  Any suggestions?

Shawn

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---