[nycphp-talk] Dynamically Add Links to Text

Paul A Houle paul at
Thu Aug 27 10:38:51 EDT 2009

Randal Rust wrote:
> The trick is that when a new article is added, they system needs to
> automatically go back to all of the existing articles and run through
> this process, which I don't like, because this won't be 100% accurate
> in the editor's eyes. each updated article needs to be reviewed. I
> also think it would cause a performance hit and dramatically slow down
> the system, especially in one installation where we have nearly 4,000
> record that would need to be updated.
    That shouldn't be a problem.  I just a ran a script that updated 
40,000 records (doing something of similar complexity) that completed in 
about 10 seconds.  If it was 4 million records,  then I might worry a 
little about performance.

    If reviewing by editors is important,  you can do this as a workflow 
system.  There's a couple ways to do it,  but basically you scan through 
the database looking for records that your system would like to update:  
rather than updating the actual records,  you insert a row into a table 
that indicates that this item should be reviewed:  the table could have 
a column that holds the new text.

    Then you write a script that shows the editor the first article that 
could be changed:  the editor then has the option to (i) accept the 
change,  (ii) edit the text,  or (iii) not accept the change.

    Currently I'm working on a system where documents get changed by 
automatic processes,  contractors,  employees,  and web users.  There's 
quite a lot of thinking of the above sort in there.

More information about the talk mailing list