• Hi!

    I have now found the problem thanks to SQL Profiler and your help :). It was caused by a bug in the script that used the built in functions in the ecommerce software to update products but it didn't reused the deliverydates why 545 deliverydates were added every hour and together with bad indexes on that table it slowed down the script and site a lot. I rewrote the script to use sql queries against the databas directly instead of the build in functions and the script now takes 6 seconds 🙂

    Thanks again for all your help! 🙂

    Regards Markus