[thesite] blockfactor revisted
.jeff
jeff at members.evolt.org
Fri Oct 26 00:19:12 CDT 2001
dan,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Daniel J. Cody
>
> > i'd guess char_len() or something like that that
> > would count the number of characters.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
i'm only guessing at the function name. there's gotta be a string length
function in oracle, just apply it to every column that's being returned and
sum them.
SELECT Sum(Len(content.contentid)
+ Len(content.keyphrase)
+ Len(content.contentname)
+ Len(content.synopsis)
+ Len(content.datemod)
+ Len(content.replies)
+ Len(content.rating)
+ Len(content.ratings)
+ Len(users.userid)
+ Len(users.who)
+ Len(categorys.category)
+ Len(categorys.categoryid)
+ Len((SELECT Count(*)
FROM replies
WHERE contentid = content.contentid
AND datemod > '#DateFormat(app.session.user.lastlogin)#')))
FROM content
, users
, categorys
WHERE ....
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> seeing that MM(allaire) wrote the software that
> communicates between CF and the DB server(more
> speficially, the DB driver), i'd say they're very
> much in control of that issue.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
that's very well a possibility.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> assuming CF is writtin in C,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
i think it's c++ actually, but close enough.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> they simply wrote some lame ass function that can only
> handle a 32K buffer( a longint in C) at a time between
> their app and the driver.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
that would be quite lame.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> dont try to blame it on open source.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
uh, i don't think i did actually.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> lets not blame problems of performance on us though.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
where did i say i was blaming them on us. i'm just trying to explore the
issues to try to find some explanations to the things we're seeing. that's
all.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> unfortunatly for MM, more people than me are thinking
> this way lately, hence the popularity of languages like
> PHP and JSP.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
or perhaps because alot of people can't see past the price tag and have zero
ability to compare the costs long term?
just my 2c,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thesite
mailing list