A more efficient way of showing the top files might be to track access in an application scope variable, and save that to a custom dmFile property every few hours.
Blair On Wed, Apr 15, 2009 at 2:47 AM, Chris Roth <[email protected]> wrote: > > Looking to do some clean up. > > 1. I have the verity plugin installed, is it safe to drop the > stats.Search table? (it looks like the verity plugin uses > farVerityLog) > > 2. The dbo.Stats table is out of control. What is the best way to > clean it up? What is it still used for? I see the reporting tab is no > longer in 5.1 but a "Statistics" option is available when Overviewing > an object (under miscellanous). > > 3. Can the entire stats functionality be disabled? If so how? > > 4. We are using Google Analytics. Has any one discovered a decent way > to track "downloads"? > > 5. One thing I do like to use (or rather am using) is a little include > that displays the top 3 downloaded files, currently it looks like > this: > > <cfscript>qGetTopFiles = application.factory.oStats.getMostViewed > (typeName='dmFile',dateRange='q',maxRows=3);</cfscript> > <cfif qGetTopFiles.recordcount> > > <cfoutput> > <strong>Check out the most popular file downloads by Cascade > Microtech's web site visitors.</strong> > <ul> > </cfoutput> > > <cfloop query="qGetTopFiles"> > > <skin:view objectid="#qGetTopFiles.objectid#" typename="dmFile" > template="displayTeaserHomePageList.cfm"> > > </cfloop> > </cfif> > > Obviously if I drop the stats stuff, this will not work. Does anyone > have a good alternative? > > TIA! > > Chris > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
