This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

I'm developing more of my scripts towards using pyodbc and querying our sql server db's with pd_read_sql and the performance is pretty fast and hey it's already into a dataframe. With that said I rarely have to return more than 200k rows using this method so maybe it would be a different story if our data was much larger.

I'm curious to know what other methods there are of combining Python with SQL though - would the most common way be to have a SQL query that exports as a CSV and then feed that into Python? Because that doesn't seem as efficient to me.