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

Leo,

Seems like there aren't enough people subscribed to the mailing list or i=
ts=20
people just aren't very supportive. I've submitted a few simple questions=
 I=20
got only a few responses, all from Sebestian (by the way, thank you=20
Sebastian). I don't know what's going on with the phpOpenTracker communit=
y.

Sergio

----- Original Message -----=20
From: "L=E9onard Wauters" <[email protected]>
To: <[email protected]>
Sent: Monday, May 09, 2005 2:28 PM
Subject: Re: [phpOpenTracker-general] Wondering about optimisations of=20
phpOpenTracker


> L=E9onard Wauters wrote:
>
>> Sebastian Bergmann wrote:
>>
>>> L=E9onard Wauters wrote:
>>>
>>>> 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'
>>>>
>>>
>>>
>>> From the excellent MySQL Manual:
>>>
>>>   "INNER JOIN and , (comma) are semantically equivalent in the absenc=
e
>>>   of a join condition: both produce a Cartesian product between the
>>>   specified tables (that is, each and every row in the first table ar=
e
>>>   joined to all rows in the second table)."
>>>
>>> By the way, most of these JOINs are longer required in phpOpenTracker=
 2.
>>>
>> 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 joi=
n=20
>> condition, or perhaps I am mistaking.
>>
>> L=E9o.
>
> No answers ?
>
> L=E9o.
>
>
> _______________________________________________
> phpOpenTracker-General mailing list
> [email protected]
> http://lists.berlios.de/mailman/listinfo/phpopentracker-general
>=20