Re: [phpOpenTracker-general] Wondering about optimisations of phpOpenTracker

L=E9onard Wauters wrote:

> Sebastian Bergmann wrote:
>
>> L=E9onard Wauters wrote:
>> =20
>>
>>> SELECT COUNT(*) AS result
>>> FROM pot_accesslog accesslog
>>>
>>> INNER JOIN pot_visitors visitors
>>>    ON visitors.accesslog_id =3D accesslog.accesslog_id
>>> WHERE visitors.client_id    =3D '1'
>>>  =20
>>
>>
>> From the excellent MySQL Manual:
>>
>>   "INNER JOIN and , (comma) are semantically equivalent in the absence
>>   of a join condition: both produce a Cartesian product between the
>>   specified tables (that is, each and every row in the first table are
>>   joined to all rows in the second table)."
>>
>> By the way, most of these JOINs are longer required in phpOpenTracker =
2.
>> =20
>>
> Of course, but in this case, there is a join condition, no ? (I'm not=20
> a pro in databases)
> For me, "ON visitors.accesslog_id =3D accesslog.accesslog_id" is a join=
=20
> condition, or perhaps I am mistaking.
>
> L=E9o.

No answers ?

L=E9o.