Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Benjamin Pflugmann
Hello. On Wed 2003-01-22 at 09:13:20 +0100, [EMAIL PROTECTED] wrote: > Steve, > > > ([Defendant] Query WITH a join - 8.79 seconds! > > EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE > > Cases.CaseNumber = Defendants.CaseNumber AND Filed <= "1999-01-01" AND > > (Defendant LIKE "

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Michael T. Babcock
Steve Quezadas wrote: PS Here is some information about my tables and indexes: Maybe I missed it, but where's the EXPLAIN on the JOIN query? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock ---

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 12:32 AM Subject: Table joins are slow things to deal with. . . > Maybe I

Table joins are slow things to deal with. . .

2003-01-21 Thread Steve Quezadas
Maybe I'm dumb for saying this, but sql joins seems expensive to do in terms of performance (yes, I indexed the joined fields). If I do a query search of a 2,600,000 record defendant table WITHOUT a join (SELECT DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE "owen%" OR Defendant LIKE