Jacob, It could possibly be eliminated if it would reduce server resources. We can consider it. Why? Is there a better way to increment a counter of some sort?
BrookD At 02:41 PM 6/13/2006, you wrote: >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:243410 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
