update from 1 row in table

Post Reply
brittonclair
Posts: 12
Joined: Wed Sep 02, 2015 6:53 pm

update from 1 row in table

Post 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!
User avatar
jason112
Site Admin
Posts: 347
Joined: Tue Oct 26, 2004 5:35 pm

update from 1 row in table

Post 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.
brittonclair
Posts: 12
Joined: Wed Sep 02, 2015 6:53 pm

update from 1 row in table

Post by brittonclair »

Thank you! I appreciate the quick and detailed response.
Post Reply