> I'd also love any suggestions/criticisms of the above architecture. I'm
> trying to address what is a potentially significant performance issue for
us
> (we hope to allow the main table to grow to tens to hundreds of millions
of
> rows before pruning it down), but there might be a much simple
I'm curious about what guarantees MySQL (and the SQL standard) provide with
regard to multiple calls to NOW() within the same statement. If the
statement takes a long time to execute, will NOW() be consistent across all
invocations?
The trivial example of this is if you're updating a large set of