Why were the views slow after migrating the data via script in Firebird 2.5?

0

I'm working on a standardized database. I recently refacted her (A) structure by renaming all existing PKs and FKs, because they had the names that are automatically generated. When migrating data from another base (B) to this refactor (A), I'm now having a very slow reading of some views, even though they have the same structure. Home When analyzing the performance, I noticed that in the new base (A) much more records are being read than in the previous one, for exactly the same query. But I could not understand why this happens. Home Below is the performance analysis print.

    
asked by anonymous 28.02.2018 / 22:07

1 answer

0

I was able to solve the problem, just recompiled the view. Well, I do not understand why, but luckily the problem is solved!

    
01.03.2018 / 19:48