Python Forum
Python Forum

Fastest Method for Querying SQL Server with Python Pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Fastest Method for Querying SQL Server with Python Pandas
BuJayBelvin
Programmer named Tim
Posts: 8
Threads: 2
Joined: Jun 2020
Reputation: 0
#3
Jul-31-2020, 04:57 PM
(Jul-31-2020, 08:27 AM)Gribouillis Wrote: Have you tried to read the table through the DB-API instead of pandas for comparison?

I haven't. I will see what I can find based on that suggestion. Are you expecting it to be faster?

Thanks!
Find
Reply


Messages In This Thread
RE: Fastest Method for Querying SQL Server with Python Pandas - by BuJayBelvin - Jul-31-2020, 04:57 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Fastest way tkinter Quatrixouuu 2 559 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,396 May-26-2023, 04:41 AM
Last Post: Gribouillis
  Method works as expected on host machine but not on server gradlon93 4 1,236 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,636 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Fastest Way of Writing/Reading Data JamesA 1 2,318 Jul-27-2021, 03:52 PM
Last Post: Larz60+
  How to take the tar backup files form remote server to local server sivareddy 0 2,038 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  Recommendations: Querying CSV / Database?? ironfelix717 2 1,761 Apr-01-2020, 12:13 PM
Last Post: ndc85430
  Passing parameters to SQL Server using pandas Ilangos 8 16,859 Jun-03-2019, 11:25 AM
Last Post: Ilangos
  Fastest dict/map method when 'key' is already a hash? tasket 6 4,205 Apr-20-2019, 06:40 PM
Last Post: tasket
  fastest way to record values between quotes paul18fr 5 3,484 Apr-15-2019, 01:51 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020