That's what databases are for tho.. to be 'quite big' ;). We have tables that have hundreds of millions rows. And as long as they're properly indexed (partitioned is super nice too) they'll fly. Don't worry about having a big db table, unless you're limited on space in the DB.
On 8/23/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > I just log the term and the date. So one row per search. This then > lets me do stuf like top ten search phrases. > > On 8/23/07, stylo stylo <[EMAIL PROTECTED]> wrote: > > Any suggestions on how best to store search terms entered on a website? > > > > If the database, then see if used already and increment, or add if not, and > > maybe set a datelastused? But then that is 2 db hits right there and could > > grow quite big. > > > > Or just write them to a file and parse and reset the whole file weekly or > > monthly? > > > > I'm thinking the latter, but how slow is writing to a file (on Linux)? > > > > it's not a heavily trafficked site, but just wondering what people do. > > > > Thanks. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
