Re: view/table slows down query although it is not used
Date: Mon, 7 Nov 2016 08:38:12 +0000
Message-ID: <nvpehg$ibf$1_at_news.albasani.net>
On 07/11/16 08:25, kfrydrys ILIM wrote:
> Thank you. After investigation i am sure that execution of Q1 is very
> slow, and the next ones are very quick, until i make "reset query
> cache".
Ok sop teh speed up is cache?
> On the other hand i compared two databases - recent and from
> month ago. On the database from month ago query Q1 always executes
> quickly (less than 1 s). I do not understand this because the amount
> of records in tables used by query Q1 is almost the same. There is
> much more data in table abc, but it is not used by Q1.
There has to be a linkage between the two tables somehow - perhaps some implicit linkage in terms of subtleSQL functions. I am at the limit of my understanding though.
Have you checked that all indices are the same on both databases?
-- All political activity makes complete sense once the proposition that all government is basically a self-legalising protection racket, is fully understood.Received on Mon Nov 07 2016 - 09:38:12 CET