Is it possible to track nano-seconds, or milli-seconds?

[Anthony]

Is it possible to keep track of the number of nano-seconds, or milli-seconds
it takes to execute a procedure similar to this:

Sub test()

Dim i As Long

Do Until i = 10000000

i = i + 1

Loop

End Sub

I wanna see how many milliseconds it takes to increment i by 1 until it
reaches 10000000

 

[Douglas J. Steele]

I don't believe you can go down to nano-seconds, but take a look at my
April, 2004 "Access Answers" column in Pinnacle Publication's "Smart Access"
for how to get more accurate timing capabilities.

You can download the column (and sample database) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Smartin]

Is it possible to keep track of the number of nano-seconds, or milli-seconds
it takes to execute a procedure similar to this:

Sub test()

Dim i As Long

Do Until i = 10000000

i = i + 1

Loop

End Sub

I wanna see how many milliseconds it takes to increment i by 1 until it
reaches 10000000

Yes (see Douglas's reply), and you might want to take a look at this
thread too:

http://preview.tinyurl.com/ygho95

 

[dbahooker]

yeah... SQL Server and _ADP_ can work with nanoseconds without a
problem.

they're rounded to the nearest timeslice; which is a group ot 30 ns I
believe

-Aaron

 

[Smartin]

yeah... SQL Server and _ADP_ can work with nanoseconds without a
problem.

they're rounded to the nearest timeslice; which is a group ot 30 ns I
believe

-Aaron

IIRC an API call makes it pretty easy to get high precision timing in
VB[A]. However for purposes of this demonstration, measurements against
Time() are enlightening.

 

[dbahooker]

or against SQL Server

-Aaron

yeah... SQL Server and _ADP_ can work with nanoseconds without a
problem.

they're rounded to the nearest timeslice; which is a group ot 30 ns I
believe

-Aaron

IIRC an API call makes it pretty easy to get high precision timing in
VB[A]. However for purposes of this demonstration, measurements against
Time() are enlightening.