speeding up paging with 400 page reports

[gotaquestion]

Is there anyway to speed up paging with the StiWebViewer?
Every time I click to another page in the viewer it goes back out and requeries the database for the results.
Is there a way to cache the results the first time in viewstate or session?
or any other ideas to speed up paging would be helpful.
Here is my code:

string reportString = "";
Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport();
string sql = "select ReportXML from reports where ReportGuid = '" + Session["ReportGuid"] + "'";
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ReportsConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
reportString = cmd.ExecuteScalar().ToString();
}


report.LoadFromString(reportString);
StiWebViewer1.Report = report;

[Jan]

Hello,

Please change CacheMode property of StiWebViewer to AjaxWithCache value. Also you don't need (in cache mode) rerender report in each PageLoad event.

Thank you.