[thesite] t.e.o. updates

[.jeff]

rudy (and dean),

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: .jeff
>
> yeah.  tried that [...]
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

nevermind, i got it working.  i just had to reload the page.

    SELECT content.contentid
         , content.keyphrase
         , content.contentname
         , content.synopsis
         , content.datemod
         , content.replies
         , content.rating
         , content.ratings
         , users.userid
         , users.who
         , categorys.category
         , categorys.categoryid
         , rand.random AS rank
      FROM content
         , users
         , categorys
     WHERE categorys.categoryid = content.categoryid
       AND content.userid = users.userid
       AND content.signoff = 1
       AND content.categoryid NOT IN (1, 23, 26, 9741)
       AND content.datemod < '#DateFormat(DateAdd("yyyy" , -1, Now()))#'
     ORDER BY rank

dean, any thoughts on why that error occurred to begin with?

(btw, props to joshua for turning me on to this solution -- one query baby,
OH YEAH)

although double-checking execution times, i'm not sure i like the penalty of
reducing it to a single query.  this single query takes an average of
500-600ms to execute.  these two queries reliably execute in sub 40ms (with
the advantage that the first one is cachable).

    SELECT contentid
      FROM content
     WHERE signoff = 1
       AND categoryid NOT IN (1, 23, 26, 9741)
       AND datemod < '#DateFormat(DateAdd("yyyy" , -1, Now()))#'

    SELECT content.contentid
         , content.keyphrase
         , content.contentname
         , content.synopsis
         , content.datemod
         , content.replies
         , content.rating
         , content.ratings
         , users.userid
         , users.who
         , categorys.category
         , categorys.categoryid
      FROM content
         , users
         , categorys
     WHERE categorys.categoryid = content.categoryid
       AND content.userid = users.userid
       AND content.signoff = 1
       AND content.categoryid NOT IN (1, 23, 26, 9741)
       AND content.contentid = #Val(getrevivedrange.contentid[RandRange(1,
getrevivedrange.recordcount)])#

based on the time differences, i think i'll stick with the two query
approach.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/