Page 1 of 1

update from 1 row in table

Posted: Tue Oct 11, 2016 1:51 pm
by brittonclair
We have a profile that has an associated DB Walker that reads a table in an external Oracle database. The walk takes over an hour to complete. The table has a primary key. Is there a way to issue a command to re-walk just one row (referencing the primary key)? Sometimes we have a change in the data in just one single row and would like to have the change reflected in the Thunderstone profile more quickly than a full walk, if possible. Thanks!

update from 1 row in table

Posted: Tue Oct 11, 2016 2:59 pm
by jason112
There is no way in the UI to force a single row to update. The "Update Soon" link in List/Edit URLs will force the record to be updated at the next walk, but that next walk may also include many other URLs too.

In situations such as this, where a record randomly updates and you want it reflected in search quickly, customers often switch to our Dataload system.

Instead of using DBWalker and "pulling" the data into the appliance, you can have your own custom code "push" data into the appliance. This could be tied into a hook in the database, so when a row is updated it gets sent over to the appliance. This would let your appliance stay up to date in real time, instead of scheduling things with walks.

update from 1 row in table

Posted: Tue Oct 11, 2016 3:09 pm
by brittonclair
Thank you! I appreciate the quick and detailed response.