You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Extremely Slow Queries against Snowflake ODBC 64 #357
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
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.
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?
Activity
snowysnowcones commentedon Aug 19, 2025
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.
quinnj-bot commentedon Nov 18, 2026
This is likely fixed. The report used ODBC.jl 1.1.2, which slept 1 ms on every
SQL_STILL_EXECUTINGpoll. 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]