Is it necessary to keep track of the date and IP address for your program? -----Original Message----- From: blists [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 11:56 AM To: CF-Talk Subject: Tracking hits/impressions DB design Considerations
Hello, I am setting out to build a basic split testing program for pages on my site. I am wondering what is the best approach to database design. Basically, I'll have two pages PAGE A and PAGE B that I want to show equally. And I want to track how many times each page is viewed, and how many times the form on that page is filled out. So basically I have two parts: Part 1 (Display): ---------------------------------------------------------------------------- --------- - Alternate between showing PAGE A or PAGE B: My thoughts on this would be to first have a table with 1 record per split test campaign. It would have the template paths and the campaign info. Then I would call display.cfm?campaignID=12 which would get the campaign from the database and then store it in the Application Scope with a flag next to the page which is currently being shown. The next request would check the application scope for the campaign and if it exists, get the item that is not flagged, redirect the user, and update the flag. Does this make sense? How should this be locked? Part 2 (Tracking) ---------------------------------------------------------------------------- - - track impressions - track actions/completions When the page loads It will include a call to track.cfm?campaignID=12&page=PAGEA&type=view to track the impression. If the form on the page gets submitted, another call to track.cfm?campaignID=12&page=PAGEA&type=action to track the form submission. My concern is regarding the DB design and how fast this would be? If my table looked like this: ======================================= SplitTestTrack_tbl ---------------------------------- id pagename campaignID type cDateTime IP ======================================= Would this be two slow? How many rows would it take before this started to run slowly? Does this design seem okay? Thanks for the advice! BrookD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
