>I just log the term and the date. So one row per search. This then >lets me do stuf like top ten search phrases.
Wouldn't you need to search for the phrase first and increment a total? Otherwise you'd have "naked" on 90,000 rows :-) And the date only refers to the last time, so not so helpful, no? That's why I was thinking a file might be better. ?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4