Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Query very slow
#6
Quote:You are combining two tables here: FROM ElectionResults2012, Places
but you only give the length of one table. What is the length of each table? The join then multiples those lengths together, and that could be millions of records of course.
This makes sense, so how do I speed up the query.
I was once an SQL whiz kid, but that goes back to the 1990's It's coming back, but slowly.
Reply


Messages In This Thread
SQL Query very slow - by Larz60+ - May-18-2019, 11:02 PM
RE: SQL Query very slow - by MvGulik - May-19-2019, 12:23 PM
RE: SQL Query very slow - by ichabod801 - May-19-2019, 02:07 PM
RE: SQL Query very slow - by Larz60+ - May-19-2019, 03:47 PM
RE: SQL Query very slow - by richalt2 - May-20-2019, 04:32 PM
RE: SQL Query very slow - by Larz60+ - May-20-2019, 05:11 PM
RE: SQL Query very slow - by MvGulik - May-21-2019, 06:50 AM
RE: SQL Query very slow - by nilamo - May-21-2019, 06:12 PM
RE: SQL Query very slow - by Larz60+ - May-21-2019, 10:34 PM
RE: SQL Query very slow - by Mark87 - Jun-23-2019, 11:43 AM
RE: SQL Query very slow - by Larz60+ - Jun-23-2019, 04:11 PM

Forum Jump:

User Panel Messages

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