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
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