The question you must answer first: what do you intend to do with the data once it's collected? Will you simply review the data without sorting it or performing data manipulation? If so, why incur the overhead of MYSQL? If all you need to do is log the user page hits, use a text file; then use grep/awk/sed/perl/php to search for specific users with their page hits, etc.
Define your requirements more explicitly, then choose a solution. -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 6:39 PM To: Georgie Casey; [EMAIL PROTECTED] Subject: RE: [PHP] A MYSQL COUNTER This is too much for a text file. You should definitely use MySQL for this. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -----Original Message----- From: Georgie Casey [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 3:22 PM To: [EMAIL PROTECTED] Subject: [PHP] A MYSQL COUNTER I need a way of tracking what user was logged in when vieweing a particular member page, so I'm thinking of having EVERY unique page view of each member page added to a MySQL database, which just the ip, time and date, server name and browser, stuff like that. Is this too much for a MySQL DB??? Should I just write all the info to a textfile??? TANX -- Regards, Georgie Casey [EMAIL PROTECTED] *************************** http://www.filmfind.tv Ireland's Online Film Production Directory *************************** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
