Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • A aisdb
  • Project information
    • Project information
    • Activity
    • Labels
    • Planning hierarchy
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 6
    • Issues 6
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Infrastructure Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • public_projects
  • aisdb
  • Issues
  • #31

Closed
Open
Created Oct 03, 2022 by Gabriel Spadon@gabrielspadon

Query speed and no db response

Hi there, I'm migrating to 1.4 to test the new viz features, but it seems that there's a bottleneck when I'm querying the database that I wasn't there before.

This is a piece of my code:

image

Before, querying 1 day of AIS data usually took ~1 minute, now is over 10 minutes, and no response. I tried to reduce the preprocessing, as it impacts the performance, but it didn't solve the issue. Any ideas of what is causing this? Let me know if you need more information.

Edited Oct 03, 2022 by Gabriel Spadon
Assignee
Assign to
Time tracking