Skip to content

Extremely Slow Queries against Snowflake ODBC 64 #357

Open

Description

@joxborrow

I am experiencing extremely slow pulls against a Snowflake ODBC 64 bit DSN. I run a basic query to pull 71 columns and 101 rows and it takes nearly 2 minutes. The same query in R on the same computer against the same DSN using the odbc package takes 0.29 seconds. I apologize if I am doing something wrong. I am rather new to Julia. Thx!

System Info:
Julia 1.8.3
ODBC.jl 1.1.2
32GB memory
10 core 2.8

Activity

  1. snowysnowcones commented on Aug 19, 2025

    @snowysnowcones

    Did you find a solve for your issue? I also have slow query performance pulling from Snowflake. 500 rows take about 45 seconds while in the web app it takes about 5.

  2. quinnj-bot commented on Nov 18, 2026

    @quinnj-bot
    Contributor

    This is likely fixed. The report used ODBC.jl 1.1.2, which slept 1 ms on every SQL_STILL_EXECUTING poll. On Windows that sleep rounds up to about 15.6 ms, and the roughly 7,000 polls a query like this makes add up to about the two minutes you saw. ODBC.jl 1.3.0 yields before sleeping (#384). Could you retry on 1.3.0 or later and say whether it's still slow?

    [comment generated via AI]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions