Re: Long Fetch times
Re: Long Fetch times
- Subject: Re: Long Fetch times
- From: Chuck Hill <email@hidden>
- Date: Sat, 13 Mar 2010 20:41:46 -0800
On Mar 13, 2010, at 4:44 PM, Jeff Schmitz wrote:
While running some stress tests I seem to be able to get my database
(Frontbase) in a state where fetch times take an inordinate amount
of time (e.g. fetches that return no rows take a minute),
Has your stress testing added any data to the database? It sounds
like you have exposed a lack of indexes to optimize your queries, or
have queries that don't optimize well.
and once in that state, even a reboot of the machine won't fix the
problem.
Are the apps and the database on the same machine? Is there any load
on the machine? Are the stress tests still running?
Is there anyway to recover such a database?
If you have actually damaged the database (which I doubt), no. I'd do
a flat file export and re-import it into a new database to see.
I'll be perusing the Frontbase for any ideas, but from experience,
is such behavior symptomatic of any particular problem? I've been
running several years and haven't until now seen such behavior.
It just sounds like you have added enough data that your queries are
no longer sufficiently performant.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden