Dave Smith wrote:
I ended up creating a TableTimestamps table and added triggers to the
tables I care about to update each table's last modified time in
TableTimestamps. Looks to be working great. This database is mostly
read, with few writes, so it ought to be good performance wise too.
--Dave
Why not just use a timestamp field on each table? I don't think it
violates any normalization rules, and you don't have to use a trigger:
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
Brandon Stout
http://mscis.org
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/
