1、If then 语句比 iif 函数 快 6倍 左右 2、Left$(string, 1)比Mid$(string, 1, 1) 快 40%左右(Right$也一样) 3、判断空字符串 Len("") = 0比"" = "" 快 2.6倍左右 4、id = 9 \ 4 比id = Int(9 / 4) 快 4.5倍,注意 \ 是整除 5、Do Until rs.EOF k = k + 1 rs.MoveNext -------------------------------------- kk = rs.RecordCount For i = 1 To kk k = k + 1 rs.MoveNext Next
注:rs 的记录有 1234567条 Do 循环比 For 循环速度慢了 20% |
|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )
GMT+8, 2024-4-28 08:57 , Processed in 0.075637 second(s), 16 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.