IDS 9.20

IDS 9.20 HC-2 on HP-UX 11.0. I posted a query a few days ago about performance degradation, but answered it myself when I discovered a runaway select/update process caused the issues. But having thought about it, and reproduced the issue with a sequential scan/delete construct, I'm still not happy. I find it hard to believe that a single query, however heavy duty, could freeze out other users to the extent it did. When it was running it could take 20 seconds to build the table list for a dbaccess->query-> info request - it was that bad. And we're talking about an HP N4000 here - a seriously meaty machine. Could it be an IDS 9.20 thing, that a single query could have such an impact? I can't remember it on7.x. Anyway, I'm going to do some comparative testing. But, if anyone does know of any issues in this area, I'd love to know. If youhave any dazzling insight could you copy it to neil.truby@londis.co.uk, as I don't get to the newsgroup too frequently. thanks Neil