Re: Urgent Request
Date: Tue, 26 Feb 2008 10:43:51 -0800 (PST)
On Feb 25, 5:16 pm, Smitty <marksmith..._at_hotmail.com> wrote:
> Hello everyone. I am really hoping that someone can help me with this
> issue. I have two identical databases (one is a replication of the
> other), where when I run an identical query on each, one returns the
> results in .5 seconds, while the other takes 18 seconds to return the
> same result. The indexes etc. are all identical on each database.
> When we ran a trace, we noticed that the disk gets hit only once on
> the 'quick' database, but get hit over 10000 times on the 'slow'
> database to return the same number of rows. Does anyone have any idea
> what could be the issue. I am attaching the query below. Thank you
> very much.
How exactly are you replicating? Is it the original or replicant that is slow? How are you determining the indices are identical? What exact version/platform are you on?
(And a gentle reminder to use descriptive subject lines in the future.)
-- @home.com is bogus. http://www.signonsandiego.com/uniontrib/20080226/news_lz1n26read.htmlReceived on Tue Feb 26 2008 - 12:43:51 CST