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

Asked

Viewed 28 times

0

I’m working on a standardized database. I recently refactored her structure (A) by renaming all existing PK and FK, because they had the names that are automatically generated. When migrating data from another database (B) to this refactored (A), I am now having a very slow reading of some views, even though they have the same structure.
When analyzing the performance, I noticed that in the new database (A) are being read much more records than in the previous one, for exactly the same query. But I couldn’t understand why it happens.

Below the performance analysis print.

performance analysis

sql firebird firebird-2.5

  • https://www.upscene.com/documentation/dbw3/index.html?fb_db_databasestatistics.htm Updated Statiscas ?

  • Thanks for the help Motta, I had already tried but this had not solved.

1 answer

0


I was able to solve the problem, I was just recompiling the view. Well, I don’t understand why, but fortunately the problem is solved!

Browser other questions tagged sql firebird firebird-2.5

You are not signed in. Login or sign up in order to post.