> between CF Server and MSSQL 2000?
>
> I run a couple of stored procedures and I am noticing that
> execution times of a specific stored procedure are at one
> time 0ms and at another time 16ms with exact the same recordset.
>
> I also ran the stored procedure in Query Analyzer in it says
> 0ms for each of the 150 itterations I've done. I want to
> bring all requests down to 0ms, so I am wondering where that
> 16ms delay is coming from? It must be between the connection
> of CF Server and MSSQL 2000. What is weird, is that it is
> always 16ms, not 1ms or 5ms, but it is either 0ms or 16ms
> (which is a quite big delay).
>
> I am using CF5 Ent. as testing environment.
>
> Anyone have good practices on this one?
Unfortunately, my earlier response to this was based on the assumption you
were using CFMX. I apologize.
With CF 5, there isn't all that much you can do to tune the database
connection from within CF itself. Make sure that you maintain database
connections.
I would recommend that you test your queries by running them through another
ODBC client from the web server's console. I suspect you'll see the same
delay no matter what ODBC client you use.
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]
