On Thu, 15 Aug 2002, Benjamin Pflugmann wrote:
> Let me try to explain.
> Last, an introduction into LEFT JOINs:
Benjamin,
this was a very good explanation. I would love to see an edited version of
your post included in the "Tutorial" section of the very fine manual.
Regards,
Thomas Spah
Hi.
On Wed 2002-08-14 at 15:06:02 -0700, [EMAIL PROTECTED] wrote:
> If you were here right now I would kiss you! Well not really, but I can not
> believe what that did!! It takes around 2-4 seconds now for the query to
> execute completely! I wish I understood when to use what type of join sin
Hi
To help improve the performance, it would help knowing
- table structures, use show create table ;
- how many records in each table
- have all the tables being analyzed/optimized recently
Inner joins whilst very useful, do impact on performance. In some cases
it is more efficient to use a s
I wrote:
>> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
>> Comp, Jobs.JobID, Employers.EmpID
>> FROM Location
>> INNER JOIN JobsLocation ON JobsLocation.LocID = Location.LocID
>> INNER JOIN Jobs ON Jobs.JobID = JobsLocation.JobID
>> INNER JOIN Employers ON Employ
If you were here right now I would kiss you! Well not really, but I can not
believe what that did!! It takes around 2-4 seconds now for the query to
execute completely! I wish I understood when to use what type of join since
it is very obvious to me that it matters, and matters greatly! Thank y
On 14 Aug 2002, at 14:46, Richard Baskett wrote:
> Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
> STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
> the new query:
You say the EXPLAIN output looks the same, so the 5 second savings is
just r
I am using 3.23.51 also
"Dost thou love life? Then do not squander time; for that's the stuff life
is made of." - Ben Franklin
> From: Rahadul Kabir <[EMAIL PROTECTED]>
>
> what version of mysql are you running? I was having similar problem then I
> upgraded my mysql to 3.23.51 and the problem
what version of mysql are you running? I was having similar problem then I
upgraded my mysql to 3.23.51 and the problem was solved.
Richard Baskett wrote:
> Ok Im still having some serious speed problems and obviously since more
> records are being added every day the problem is getting worse.
Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
the new query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Location
INNER
On 14 Aug 2002, at 14:09, Richard Baskett wrote:
> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
> Comp, Jobs.JobID, Employers.EmpID
> FROM Employers
> INNER JOIN Jobs ON Employers.EmpID = Jobs.EmpID
> INNER JOIN JobsLocation ON Jobs.JobID = JobsLocation.JobID
> INN
Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse. Here is the
query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN Jobs
11 matches
Mail list logo
