Clock how long it takes code to run?
Hello. I have several pieces of code that do the same exact thing,
but are written differently. Is there a way to measure the time it takes for a piece of code to run so I can determine which runs fastest? Thanks!! |
Clock how long it takes code to run?
On 2 Jun 2004 12:58:25 -0700, Steph wrote:
Hello. I have several pieces of code that do the same exact thing, but are written differently. Is there a way to measure the time it takes for a piece of code to run so I can determine which runs fastest? Thanks!! Here's a simple method that works for me. It's not terribly accurate - you get fairly significant variations depending on what else your system is doing; best to use an average of several runs... Dim m As Single, n As Single, o As Single m = Timer 'your code here n = Timer o = n - m MsgBox o -- auric underscore underscore at hotmail dot com ***** Halmark's on the line; they want their lyrics back. |
Clock how long it takes code to run?
If you want a more reliable method, check out Karl Peterson's Stopwatch code
at http://www.mvps.org/vb/index2.html?tips/benchmarks.htm -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Auric__" wrote in message ... On 2 Jun 2004 12:58:25 -0700, Steph wrote: Hello. I have several pieces of code that do the same exact thing, but are written differently. Is there a way to measure the time it takes for a piece of code to run so I can determine which runs fastest? Thanks!! Here's a simple method that works for me. It's not terribly accurate - you get fairly significant variations depending on what else your system is doing; best to use an average of several runs... Dim m As Single, n As Single, o As Single m = Timer 'your code here n = Timer o = n - m MsgBox o -- auric underscore underscore at hotmail dot com ***** Halmark's on the line; they want their lyrics back. |
Clock how long it takes code to run?
To start with, at various points in my code I use, e.g.
[h1].Value = Time [h2].Value = Time [h3].Value = Time [h4].Value = Time etc This enables me to determine time taken for a particular piece of code to execute. - Works for me! Martin Steph wrote in message om... Hello. I have several pieces of code that do the same exact thing, but are written differently. Is there a way to measure the time it takes for a piece of code to run so I can determine which runs fastest? Thanks!! |
All times are GMT +1. The time now is 08:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com