Running a COUNT query on a table basically made Firebird unresponsive and is holding up all other queries to that table (and Firebird itself).

Is there a way of stopping a long-running query WITHOUT bringing the whole DBMS down?