Thank you all for your help with this topic... very helpful. ~Chad
On 8/7/07, Lonnie Olson <[EMAIL PROTECTED]> wrote: > > On Tue, 2007-08-07 at 14:51 -0600, Kirk Cerny wrote: > > The index on session_date_created will ONLY help if it is by itself in > > the comparison such as > > > > DELETE FROM session_table WHERE (UNIX_TIMESTAMP(now()) - 8600) < > > session_date_created > > > > if there is any calculation done on session_date_created the index > > will not have any effect. > > Cool, I didn't know that. Thanks. > > --lonnie > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > -- /--------------------------/ Chad Sollis [EMAIL PROTECTED] 801.792.7651 _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
