> latencies of 16ms are no problem, but this is the case where
> you have pages with for ex.
> 10 calls to stored procedure, checking childs, checking
> access, checking poll results, checking latest news, etc.
>
> The sum of all those latencies is at my point 110ms, while
> each query executes with 0ms in QA. This means ColdFusion
> Server is adding a latency of 110ms on each request, no
> mather how fast your server will be. The only thing I can do
> is putting the results in memory resident variables to speed
> up the process (either session, application or just a
> cachedwith timespan) and that is a pitty, especially while we
> use ColdFusion for Enterprise purposes and not for
> honkietonkie hobby stuff.
You shouldn't be seeing that latency if you're running multiple queries
within the same page that use the same database connection. Do you have the
"maintain database connection" option enabled within the datasource
settings? Are you using the most recent JDBC drivers from the MM site? As an
alternative, you might also try MS's own JDBC driver too.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
