Re: view/table slows down query although it is not used

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.