Re: same query is now 30 times slower
From: Mike <okana!!nofuckingsp|am!!~_at_!!nofuckingsplam!!~voidnet.!!mapson!!.com>
Date: Thu, 28 Mar 2002 10:32:22 -0700
Message-ID: <fvIo8.20479$x51.323661_at_news.webusenet.com>
Date: Thu, 28 Mar 2002 10:32:22 -0700
Message-ID: <fvIo8.20479$x51.323661_at_news.webusenet.com>
What else is going on in the database at the same time?
Were indexes removed or changed?
"Jason Separovic" <sepo_at_bigpond.net.au> wrote in message
news:0wWm8.1981$EE4.6978_at_news-server.bigpond.net.au...
> Has anyone ever experienced a problem where a nested select statement
which
> first took a minute now takes half an hour. It is the exact same query on
> the exact same dataset on the exact same database.
>
>
Received on Thu Mar 28 2002 - 18:32:22 CET