Default to DB_TXN_WRITE_NOSYNC for all transactional operations