based on the search time which is best, stats or transaction.
Hi @Ramana246,
use stats all the times you can,
in other words, you have to use transaction (that's very slow command) only if you have to use a condition as startswith or endwith.
Ciao.
Giuseppe
stats, hands down.
Thanks