Hi!

Thanks for the replies! 🙂

The database comes with nopCommerce (a free ecommerce software) written in c# and the script updates the Product table were the names, prices, deliverydates, prices, stockqtys etc. are updated. It is run once an hour. From the start the database contained about 535 products and only 10 have been added so toalt rows now in the product table is 545. The script uses the built in functions in nopCommerce for updates and inserts so I have not written the queries myself.

If I change and use the old backup of the database the run time of the script is back to 2 minutes why there must be somthing that has happened to the production database... Tha database size now is only 8 MB bigger so not much difference there eather...

Regards Markus