I am running latest version of mydbr (5.5.0) on XAMPP. It is very important for my customer for one of the reports/screens in my application to be as fast as possible. I have timed the stored proc producing this report and its execution takes about 1 second. When I look at report stats in MyDBR it actually shows execution time being between 2 to 4 seconds. However, when I time the report as user would see it in browser, it actually seems much longer - could be 5-7 seconds from the click on submit button till the page is fully rendered.
I must say the resultset I have is very small - probably no more than 10 rows. There are no charts or graphs, just some basic columns with text. There is styling and some conditional display of the columns (logic is in the proc). Plus, most columns are clickable as sub-reports or external links etc.
I am wondering what is the expected ratio between stored proc run time and page rendering time should be in case like I have described?
What can be done to improve performance (besides stored proc optimization of course)?