Links

• Datadog: Link info about this query
• AWS RDS Metrics (Link~(~(expression~'ANOMALY_DETECTION_BAND28m22c20229~label~'apploi-production2028expected*29~id~'ad1~color~'23666666~region~'us-east-1~visible~false))~(~'AWS2fRDS~'CPUUtilization~'DBInstanceIdentifier~'apploi-production-read-replica~(id~'m4~visible~false))~(~'...~'apploi-prod-aurora~(id~'m1))~(~'...~'apploi-prod~(id~'m3))~(~'...~'apploi-prod-aurora-us-east-1a~(id~'m5)))~view~'timeSeries~stacked~false~region~'us-east-1~title~'db-CPUUtilization-prod~period~300~stat~'Average~start~'-PT3H~end~'P0D)))

• Two weeks after fix
• Pending to compare the price, capacity and performance of old Database with the new Database

Example

• We can create this query = ProcessedApplication.query.limit(10)

  • Link to the Github model.
  • We expected
  • Query

• What we can do?

  • Using Load property
    • example
  • update the lazy attribute in the relationship

• Defer

  from models.jobs import Job
  from database import db
  from sqlalchemy.orm import defer
  query = db.session.query(Job)
  query = query.options(defer(Job._company_logo_url)).order_by(Job.id.desc())
  

Documentation

• SQL Alchemy: Lazy Property and defer