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

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 a=20
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.