select(row|all) will prepare and execute a query in one step. That’s handy when you only need to run a query once, but if you repeat it, it will re-prepare the query every time.

If you prepare the query manually, you can execute it repeatedly without preparing it more than once.

Makeshifts last the longest.