Have you made changes to the structure of the db or etc? A backup
restore should resolve. I seem to recall when I was first messing with
FB, doing something with tables that was similar. Would almost freeze
the engine, don't think it crashed, but maxed out CPU and etc.

If possible. You might want to recreate the structure of the db, via
meta data and etc. Then pump the contents into the new empty db. Time
intensive, but if you have tried everything else, might be worth while.

Although I assume that's what a backup does? Restores structure, then
pumps, populates data in steps?

--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com