There have been no changes to the database structure in the past few weeks,
so I can't imagine that causing the problem.

I will probably leave your suggestion as a last resort, mostly because of
the amount of time it would take and I would also assume that the normal
backup & restore would do the same kind of thing.

Thanks

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of William L. Thomson
Jr.
Sent: Thursday, December 15, 2005 1:20 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Our firebird database performance
hascome to a halt

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




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/200 - Release Date: 12/14/2005


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/200 - Release Date: 12/14/2005