im writing a function that is going to go thru about 150 elseif statements and started thinking maybe case would be faster. which one is faster or are they both the exact same?
Cases are definately faster. If you are using ElseIf statements the code normally has to check every single item and do a comparison. Case's set up the comparison value at the start.
Function ReturnMemberConfigData(sID) Select case cint(sID) case 1 ReturnMemberConfigData = "Rather Not Say" case 2 ReturnMemberConfigData = "Other" case 3 ReturnMemberConfigData = "African American" case 4 ReturnMemberConfigData = "Asian" case 5 ReturnMemberConfigData = "Caucasian"
in small tests, ifelse and cases are near identical, but in LARGE selections, yours will work for this example, having to make a comaprison 149 times is much more time consuming.
A case does not have to compare at each elseif statement, it simply jumps to its given line.
Writing for small processors and such, you'd much prefer to have a case than else ifs. For the systems today, it really doesn't matter as their speed and RAM is so much the simple calculations for comparisons doesn't make much of a dent.
Topic Locked
Posted - 16 April 2001 : 12:24:04
