On Tue, 03 Dec 2002 12:47:28 +1100, Justin French wrote:
>my php script looks for a row matching this year (2002), this
>month (12) and this page (something.php)
It would seem like one index on year/month/page would be
appropriate then. It could be used for both lookups and for reporting
Hi Justin,
> I'm after a little help/advice with indexing...
> I have a table for measuring hits on each page within a site:
> year month page hits
>
> basically, my php script looks for a row matching this year (2002), this
> month (12) and this page (something.php). if it finds it, increment by
Hi All,
I'm after a little help/advice with indexing...
I have a table for measuring hits on each page within a site:
year month page hits
basically, my php script looks for a row matching this year (2002), this
month (12) and this page (something.php). if it finds it, increment by 1,
otherwis
