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

L=E9onard Wauters wrote:
> SELECT COUNT(*) AS result
> FROM pot_accesslog accesslog
>=20
> 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 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
Sebastian Bergmann                      http://www.sebastian-bergmann.de/
GnuPG Key: 0xB85B5D69 / 27A7 2B14 09E4 98CD 6277 0E5B 6867 C514 B85B 5D69