Python Forum
Fastest Method for Querying SQL Server with Python Pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fastest Method for Querying SQL Server with Python Pandas
#5
BuJayBelvin Wrote:Are you expecting it to be faster?
Yes. In fact I'm a complete begginner in pandas but I read that pandas uses sqlalchemy and I have some bad memories of sqlalchemy being much slower than the DB-API in certain situations. It could really change something.
Reply


Messages In This Thread
RE: Fastest Method for Querying SQL Server with Python Pandas - by Gribouillis - Jul-31-2020, 06:00 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Fastest way tkinter Quatrixouuu 2 466 Feb-19-2024, 07:20 AM
Last Post: Danishhafeez
  What is the fastest way to get all the frames from a video file? glorsh66 3 1,183 May-26-2023, 04:41 AM
Last Post: Gribouillis
  Method works as expected on host machine but not on server gradlon93 4 1,143 Jan-05-2023, 10:41 AM
Last Post: DeaD_EyE
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 1,450 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Fastest Way of Writing/Reading Data JamesA 1 2,241 Jul-27-2021, 03:52 PM
Last Post: Larz60+
  How to take the tar backup files form remote server to local server sivareddy 0 1,950 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  Recommendations: Querying CSV / Database?? ironfelix717 2 1,691 Apr-01-2020, 12:13 PM
Last Post: ndc85430
  Passing parameters to SQL Server using pandas Ilangos 8 16,635 Jun-03-2019, 11:25 AM
Last Post: Ilangos
  Fastest dict/map method when 'key' is already a hash? tasket 6 4,073 Apr-20-2019, 06:40 PM
Last Post: tasket
  fastest way to record values between quotes paul18fr 5 3,370 Apr-15-2019, 01:51 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020