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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4