Well as a benchmark, I basically took something like
<html><body>Some stuff <<SomeMergedStuff>> more stuff</body></html>
and replaced it with
'<html><body>Some stuff ' + SomeMergedStuff + ' more stuff</body></html>'
The case in point was a page that was huge, 7 meg. (Obviously 7 meg is an unreasonably large web page any way you look at it, but sometimes things just work out that way)
Anyway it worked out to be 38 times faster the latter way.
I mean, 7 meg is huge, and when our users were generating pages that large and getting timeouts our basic reaction was "well, 7 meg is way too large a page, sorry". But it was taking the Foxpro merge something like, if I recall correctly, 4 or 5 minutes. That seems like a long time to move 7 meg of data from point a to point b.
If I could speed up the process by a similar scale, there are other parts of our system that would benefit immensely. As you say though, while it's relatively straightforward to do for merging variables, it's a problem for dynamic function calls ( <<CallMyMergedFunction()>> ).
Sent by FoxWeb Support on 01/20/2003 05:19:54 PM:
Actually MergeTxt is based on VFP's merge functionality, which is pretty fast. Although it relies on sending the output to a file and then reading the file back into the html_out variable, it's (surprisingly) almost twice as fast as VFP 7's new TEXTMERGE function, or even the new TEXT TO MEMVAR option.
What do you mean by hand-coded replacements? Are you referring to the use of STRTRAN? We have seen STRTRAN be really slow with large amounts of data. In such cases we have used the RegExp object, which is part of Microsoft's scripting library. The problem with STRTRAN and RegExp is that there's no real expression evaluation, so you can only cover a relative small number of replacement tags.
FWX scripts use totally different technology than MergeTxt. With FWX scripts, FoxWeb converts the script to a regular PRG file and inserts calls to Response.Write as necessary. Performance will vary between the two methods and will depend on the size of your HTML output, the number of replacements and the relative speed of your CPU and your hard-drive. We recommend that you run tests with your own scripts to determine which method will work best for you.
Sent by Joe Cosby on 01/20/2003 12:13:43 PM:
Has anybody who was using Foxweb 1.x and upgraded ever tested the speed comparison between mergetxt and the fwx approach used in the newer versions?
We are in the midst of upgrading from 1.x . I was working on replacing the mergetxt with something faster, mergetxt seems to be fairly slow with large pages. I have been able to replace it with hand-coded replacements and in some cases they were as much as 30-40 x faster.
If the fwx approach is significantly faster already though, I could just switch to that and save myself a lot of work
Thanks for any responses