efficacious Posted June 2, 2011 Share Posted June 2, 2011 I have setup a table in my DB for recording activity on the website.. the site records basic information every time a user visits a page: the id of the user, the current time, the current date, the page the user was visiting, and the users IP information. So far it seems to be working very well. But I am a bit worried that the table will become extremely cumbersome. For instance atm I am the only person who knows of the site and visits it so just from my activity on the site there is 91 records. Should I be worried about this becoming a problem when the site is open to more users? Any1 have any suggestions of a better way? Thanks for your replies. Quote Link to comment https://forums.phpfreaks.com/topic/238247-record-site-activity-via-db/ Share on other sites More sharing options...
fenway Posted June 2, 2011 Share Posted June 2, 2011 You don't have to log this in the DB -- but if you do so, just use INSERT DELAYED. Quote Link to comment https://forums.phpfreaks.com/topic/238247-record-site-activity-via-db/#findComment-1224409 Share on other sites More sharing options...
efficacious Posted June 3, 2011 Author Share Posted June 3, 2011 well i figured it was either log it in the DB or to a text file and with the DB option I can use the records to check for other users online status as well as other things.. Good tip with DELAYED modifier for the INSERT statements.. I never heard of that before. thanks. Quote Link to comment https://forums.phpfreaks.com/topic/238247-record-site-activity-via-db/#findComment-1224437 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.