> -----Original Message-----
> From: Earl, George [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 13 april 2004 16:40
> To: CF-Talk
> Subject: How to streamline a request that uses many cfquery
> statements?
>
> This feels like a dumb question, but here goes . . .
>
> Am I correct that in a CF template that has, say, 15 cfquery
> statements the cfquery statements are submitted one at a time
> with each subsequent cfquery not submitted until the previous
> cfquery returns? I.e., if all 15 queries have to run and
> there is no logic in the markup that arranges or rearranges
> the order in which the queries run do they run one at a time
> in sequence from top to bottom?
>
> Is there a way to have multiple queries running from the same
> cf template at the same time?
>
> We produce a report that is essentially three reports bundled
> into one and displayed one after the other. Currently we run
> 15 queries (3*5) to create this report and it takes 3 - 3 1/2
> minutes for the queries to complete.
> Logically it seems that we could run the three report
> processes concurrently and independently and then assemble
> them into the final report when the answer sets come back
> which should dramatically speed up the process. Is there a
> way to do this with CF?
>
> (We're using Oracle 8i, CF5, migrating to CFMX 6.1, on
> Windows 2000 Advanced
> Server.)
>
> Thanks!
>
> George
> [EMAIL PROTECTED]
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
