Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Optimize database queries #508

Closed
3 tasks done
Tracked by #3
Uxio0 opened this issue Nov 23, 2021 · 3 comments
Closed
3 tasks done
Tracked by #3

Optimize database queries #508

Uxio0 opened this issue Nov 23, 2021 · 3 comments
Assignees
@Uxio0
Labels
enhancement New feature or request

Comments

@Uxio0
Copy link
Member

Uxio0 commented Nov 23, 2021 •
edited
Loading

What is needed?

  • Check atomic blocks and make it as little as possible
  • Optimize long time consuming queries
  • Analyze if we can apply more caching
@Uxio0 Uxio0 added the enhancement New feature or request label Nov 23, 2021
@Uxio0 Uxio0 self-assigned this Nov 23, 2021
This was referenced Nov 24, 2021
Merged
Merged
@Uxio0 Uxio0 mentioned this issue Dec 10, 2021
Merged
@Uxio0
Copy link
Member Author

Uxio0 commented Dec 15, 2021 •
edited
Loading

Size of databases before #529 (staging):

  • Mainnet: 18 Gb
  • Rinkeby: 3.597 Gb
  • Polygon: 16 Gb

Size of databases after #529:

  • Mainnet: 8 Gb
  • Rinkeby: 1.304 Gb
  • Polygon: 13 Gb

Time spent in migrating production data (with staging database, with way less resources than the production one):

  • Mainnet: 20 minutes
  • Rinkeby: 5 minutes
  • Polygon: 15 minutes

@Uxio0
Copy link
Member Author

Uxio0 commented Dec 22, 2021 •
edited
Loading

Size of databases before #529 (staging):

  • Mainnet: 18 Gb
  • Rinkeby: 3.597 Gb
  • Polygon: 16 Gb

Size of databases after #529:

  • Mainnet: 8 Gb
  • Rinkeby: 1.304 Gb
  • Polygon: 13 Gb

Time spent in migrating production data (with staging database, with way less resources than the production one):

  • Mainnet: 20 minutes
  • Rinkeby: 5 minutes
  • Polygon: 15 minutes

I updated the info @gnosis/safe-services

@Uxio0
Copy link
Member Author

Uxio0 commented Jan 11, 2022

I think this should be complete for now, as we don't see any database issues on production since the last optimization update

@Uxio0 Uxio0 closed this as completed Jan 11, 2022
@Uxio0 Uxio0 mentioned this issue Jan 28, 2022
Open
3 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Uxio0 Uxio0

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Uxio0