> Yes, but... [snip]
What I am saying is that there are probably not very many situations where
it would make sense to use both solutions. The foremost question is not
"which is faster", but "which is more practical for my app". It's like
saying, which is faster Client or Session variables? The answer is really
not relevant because in most situations it really only makes sense to use
one or the other.
> Right, but can we use the struct functions on a query to the effect of
> running a query on it?
What?
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
> -----Original Message-----
> From: Jennifer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 3:36 PM
> To: CF-Talk
> Subject: RE: cached queries vs. structures was(Re: ...BETA...!! (query a
> query))
>
>
> At 02:38 PM 2/2/01 -0500, you wrote:
> > > I'd like to see some statistics on cached queries vs. querying a
> > > structure.
> >
> >It would entirely depend on who you are planning on using your
> data. It's
> >like comparing apples and oranges.
>
> Yes, but if I could get some idea what the difference in
> performance is for
> a given number of queries of a certain size with the contents used a
> certain number of times, I could infer how it would affect my particular
> system. It wouldn't be exact but it would be a better prediction
> than I can
> make now. Several sets of circumstances could give me even better
> results.
> Scientific method and graph interpolation and all that....
>
> >Incidentally, a query in CF can be treated like a structure already. You
> >can pull records out of a query using the following format
> >QueryName[ColumnName][RowNumber].
>
> Right, but can we use the struct functions on a query to the effect of
> running a query on it?
>
>
> Now announcing my newly updated website
> http://www.blivit.org/mr_urc/index.cfm
> Resume: http://www.blivit.org/mr_urc/resume.cfm
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
