Hi Guys
I’m updating asset names using mysql query.(becase api calls are slow). Razuna’s web interface showing old asset names unless I go to Administration> Maintenance and flush database cache.
Is there a query for this functionality?
Thanks in Advance.
Farhad
No, because you are circumventing the whole mechanism by going directly to the database. You can’t do that and expect the system to still work.
Regarding “slow API calls”, since this is your own setup, you should look into memory and tuning options. API calls are fast, if not faster then UI calls. So there is definitely something amiss in your installation.
Hi
For those who may have the same problem:
Update raz1_images column is_indexed to 0 in databse 
this seems to trigger an update on webinterface and search indexing too.
Have fun
Farhad
As I have outlined in my previous post, you are circumventing the system by going to the db directly.
Since 1.7, and now enhanced in 1.8, there is an option to re-index the search index directly within Razuna which does all that and takes care of proper flushing of the cache and more.