I need this for logging in a multiprocess, multithreaded environment.
I understand that the CPU does other things but even when I have multiple callers call the logging SP (I have one field in the DB with a default getdate() ) I can not break the 14 or so ms barrier.
The second example does not show the getdate() granuality but the DATETIME granuality. I am wondering if the gatdate() inherently can not handle the full spectrum of DATETIME values.
Do you have access to a fast PC that you could run this test and see if on a faster machine you get better then the 14 ms?
The one I am using right now is a single core 2.13GHz
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]