Make Websites faster when there is sql query working on behind

I am using simple application built on groovy on grails. I display in a website the sql query results, which are computed behind in groovy service code (using groovy sql), which is then passed to gsp (Javascript) page for view.

The SQL query takes long time to execute, hence there is delay in web page being loaded. We have already worked on indexing the tables, computing schema statistics.

What's the other way to make it faster? I could think of generating a view with sql query results already computed. And just use the view instead of calling the sql query which computes the results.

Whats the other way to make it faster? Any help or ideas would be appreciated.