Frequent Database Posting
Posted: Thu Dec 28, 2006 12:50 pm
Hi, I have a concept for tracking a users visit to my flash site, and it would require information to be posted to a mySQL database frequently. Each time they click on a project it will post the amount of time they spent on the last project. I would say the average visitor to my site would probably make about 2-8 posts in the span of 2-8 minutes. Currently my site receives around 100 sessions/day, but this is expected to increase soon. Will this procedure be a problem for my database, bandwidth or server? is there a better method to retrieve this information?
ultimately this data will be utilized in a 3-dimensional bar graph, displaying project views, duration spent, and votes for favorites. The site this will be implemented into is http://www.haptic-data.com and under "post analysis" is a beta (xml-only) version of the dynamic graph.
Thank you!
ultimately this data will be utilized in a 3-dimensional bar graph, displaying project views, duration spent, and votes for favorites. The site this will be implemented into is http://www.haptic-data.com and under "post analysis" is a beta (xml-only) version of the dynamic graph.
Thank you!