RE: Joins are slow

ROTECTED]] Sent: Tuesday, January 21, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: Joins are slow 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 WI

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

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. . .

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: Joins are slow

On Wed, 2003-01-22 at 03:18, Steve Quezadas wrote: > > ([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 "owen%" OR Defendant LIKE "pitts%"

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

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. . .

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

Joins are slow

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

Joins are slow?

Scott Ambler recommends in his publication " Mapping Objects to Relational Databases" not to do joins but to traverse tables. He claims that 'several small accesses are usually more efficient than one big join'. Is that true for mysql? I am particularly interested in a scenario where I would retrie