>As I said earlier whatever they do, they have on job that makes this go from some 80
>(which I find a lot still) to 1700+. And its is 24/7.
>
>The system should is supossed to look for some stock changes, and then make som entrys to
>fill up items in the store.
>
>This customer has some 40 shops.
>And sinse these shops on average have a sale every second minute, this routine (whatever
>it does) does it i my opinion way to much.

Here's a guess what they may be doing:

Almost every second each shop start a transaction that start a query looking for changes in the database (possibly monitoring a logging table).

If this is the case, then I guess teaching them about database events might solve your problems (I don't know, cause I don't use events myself).

HTH,
Set