I prepared simple script updating product stock via Magento API ( I followed this http://www.magentocommerce.com/wiki/doc/webservices-api/api/cataloginventory_stock_item#cataloginventory_stock_item.update and http://www.magentocommerce.com/boards/viewthread/32651/) and everythink works fine.
But I think is a little bit slow if I need to handle thousands of products.
Stock update of 50 products take 100 seconds.
Ok, so I try to find which queries are done during updating and I found for example this one
I think it’s not related to stock update, isn’t it?
UPDATE `catalogsearch_query` SET `is_processed` = '0'
Can anyone help me how to improve performance of updateing stock? How to disable all unrelated queries? etc.