siplus

Search speed, numeric vs text field

Discussion created by siplus on Mar 15, 2015
Latest reply on Mar 18, 2015 by siplus

Apparently, searching on a numeric key vs doing it on a text key is 4 to 5.5 times faster.

 

Of course the real impact might be negligible, but nevertheless. Of course, I might be wrong somewhere.

 

Please run the first 3 scripts first, then test with the fourth.

Attachments

Outcomes