[AccessD] Naming Conventions

Arthur Fuller artful at rogers.com
Thu Aug 5 17:04:26 CDT 2004


You may well be right, Drew, but I can't get my computer to report a
difference in the speeds, no matter how high I increase both boundaries.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
DWUTKA at marlow.com
Sent: Thursday, August 05, 2004 4:41 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Naming Conventions


Because:

Dim i As Long
Do until i=100
	i=i+1
loop

Runs faster then 

Dim i as Integer
Do Until i=100
	i=i+1
Loop

Why declare a counter with a prefix?  If you are using an integer, for
'smaller' counts, then whether you are using a prefixed variable or not,
you're still missing the point.

Drew




More information about the AccessD mailing list