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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4