Update a lookup file in realtime

[chris]

I know outputcsv does not update (it should just append to) a lookup table until the search is finalized. Is there any other way this could be done?
Or is the best way to run a search every couple of minutes and write the csv?

Thanks,
Chris

[Ledion_Bitincka · Accepted solution]

Updating CSV files is an expensive process because they cannot be updated in place. Even if you were able to update the lookup table in real time, due to bundle replication it will still take at least one minute before the lookup table gets to the indexers.

There are 3 ways you could update the lookup table
1. periodically run the search
2. write a custom search command that does what you want
3. use the MysqlConnector app, this app offers great lookup update performance