Performance
The DBI is built for speed
The DBI overhead is usually insignificant
prepare()
Use placeholders
Don't use do() in a loop
Use prepare_cached()
Use fetchrow_arrayref() or bind_columns()