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?
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
