Runaway SQL Query

[Anonymous]

I'm told there's no graceful way to kill a runaway SQL query in ArchiCAD. Does anyone know of a workaround that will kill the query without killing (or hurting) ArchiCAD too? The application becomes unresponsive, but does NOT indicate "Not Responding" as sometimes applications don't. I have let it run for up to 4 hours without it hanging. That wastes time, but not as much as trashing the database might.

[Karl Ottenstein]

Don't know of any way to kill just the query, Didrik. Since the query process is 100% read-only, no damage to the database can happen by killing the process. The only issue would be if there are unsaved changes in the project before you start the query.... they would most likely be lost unless you are prompted for an auto-recovery file when you relaunch AC. Well, there might be some temporary files left hanging about from the query somewhere, too. But, no harm to the project itself.

Cheers,
Karl