Skip to main content

Query for 600,000 records takes 30 minutes to run!?


1 comment

  • Official comment
    Alon Brody

    There are a few reasons that can cause a query to run for so long (or not completing at all):

    • The JOINs conditions that are being used multiply the number of records in an unsensible factor
    • The amount of data that is being returned overload the memory of the receiving client (workbench or BI tool)

    In this specific case, it was the latter that caused the issue. We need to keep in mind that most tools are not built to handle and display thousands and thousands of records and the best option in most cases is to add an additional transformation on the query level to aggregate the results into the desired end (or near-end) result you are looking to have.

Please sign in to leave a comment.

Powered by Zendesk