>something. is it just because the oracle driver does not allow multiple
>queries in the same cfquery and the mssql driver does? is there any way i
>can get around this. i really don't want to have to break that statement
>out into another query. i'm sure there is a performance hit of some sort.
>i want to make this as scalable as possible and am trying to follow that
>idea in all the code. plus it would just be annoying to have to do another
>cfquery just to only execute one more command.
>
1. If you're looking for performance and scalablity, then your SQL should be
in stored procs to begin with, rather than inline SQL.
2. Since CF caches the connection to the database, the "overhead" of making
the second call is so negligible you can safely say there is none.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]