All geek questions in one place

Related tables in Red-Gate SQL Source Control (SSC) - Performance Nightmare?

Our team uses Red-Gate SQL Source Control as our CM database tool. After performing a quick test to determine how static data binding affects the speed of SQL Source Control, I got the following results:

  • 1st run - 85 seconds (26 related tables with data 13.9 MB)
  • 2nd run - 14 seconds! (0 related tables)

I started with 26 related tables in my database. It took about 85 seconds for SQL Source Control to show the changes to Commit Commites. After I deleted all the related tables, it took only 14 seconds. Before each start, I restarted SSMS.

  • Does anyone have any other similar problems?
  • What other tools / methods besides SSC would you recommend for SQL DB CM and storing static data? (Something that is desirable as easy to set up and use in a large team)

Until Red Gate resolves this performance issue when linking static data, we are considering using SQL scripts to place data under source control.

+6
source share
1 answer

We are launching version 3.0.12.3695 and have exactly the same problems. This issue has already been reported on their forums and in the support team. If you are using version 3.0.12, this may help you: Overall performance

+1
source

Source: https://habr.com/ru/post/915130/

More articles:


All Articles