RE: [PHP] Newbie challenge to brainiacs
| From: | Jay Blanchard | Date: | Tue, 14 May 2002 13:03:02 +0000 |
| Subject: | RE: [PHP] Newbie challenge to brainiacs | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-97528@lists.php.net to get a copy of this message | ||
[snip]
> I want to try to find the hour that has the most hits
> The day of the week that has the most hits
> and the max and ave no of hits of these.
I haven't given it a whole lot of thought but I'd be tempted to dump the
whole thing into an appropriately structured sql database and then use
SELECT's to extract the information you want. It'll likely end up
faster and less processor intensive than doing it in php by itself I
suspect.
[/snip]
+1
Not only that, but then you will have the ability to create queries for
other important factors in the logs without having to recode, or create
code.
Jay