SQL Query very slow

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

SQL Query very slow

richalt2
Unladen Swallow

Posts: 2

Threads: 1

Joined: May 2019

Reputation: 0

May-20-2019, 04:32 PM

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.

Find

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

Users browsing this thread: 1 Guest(s)

View a Printable Version

SQL Query very slow

User Panel Messages

Announcements