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

] To: [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 12:32 AM Subject: 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

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% OR

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: 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 owen% OR

RE: Joins are slow

: 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 WITHOUT a join (SELECT

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

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?

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