< :the previous in number  ^ :the list in numerical order  > :the next in number  P :the previous aricle (the previous thread)  N :the next (in thread) |<:the previous thread >|:the next thread  ^ :the parent (reply-to) _:the child (an article replying to this) >:the elder article having the same parent <:the youger article having the same parent ---:split window and show thread lists  | :split window (vertically) and show thread lists  ~ :close the thread frame .:the index ..:the index of indices

Subject: running a ruby script once a week automatically
From: "jotto" <jonathan.otto@ a . m
Date: Sat, 14 Oct 2006 00:40:16 +0900

I have a SQL query that examines an entire column (right now 25,000
rows, but growing fast), it finds the top 50 most common elements in a
column. To reduce load, I want to execute this script only once a week
instead of every time the page is loaded.

What is the best way to do this? Just run a cron job that executes a
Ruby script once a week? Or does MySQL have something built in for this?