Most important and easiest: If you have a known set of SELECT statements to execute, for example you know you're going to need to look up four values, put them in a transaction, i.e. surround them in BEGIN and END. Less easy: Where convenient, use a number of pre-prepared statements and just rebind and restep them, rather than preparing a new statement every time.