same query is now 30 times slower
From: Jason Separovic <sepo_at_bigpond.net.au>
Date: Sat, 23 Mar 2002 07:52:44 GMT
Message-ID: <gvWm8.1978$EE4.6988_at_news-server.bigpond.net.au>
Date: Sat, 23 Mar 2002 07:52:44 GMT
Message-ID: <gvWm8.1978$EE4.6988_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 Sat Mar 23 2002 - 08:52:44 CET