in reply to bind_columns OR fetchall_arrayref

Make sure you measure everything. Are you getting adequate performance? If you're currently getting adequate performance, then you don't need to speed it up.

There are a number of potential bottlenecks in your page display:

Bottom line is that you don't go optimizing until you KNOW where your bottleneck is. If your query returns in 1 second and your page takes 5 seconds to draw because you're using some slooooow templating system, then the DB is not the problem.

xoxo,
Andy