Hello everybody, I have a problem in generating the report. It takes 1 and half hours just to view my report. Is there anyone know how to make it fast. Im using MySQL and i used 16 views for my report thats why its very tedious.
Thank a lot!!!Whatever query or stored procedure u r using execute it outside report and test the time.|||Also check that the fields you are joining on are indexed. When you look at the SQL for the report is there a where clause? If not the entire report is being processed on the local machine. Do you have the option "perform grouping on server" checked?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment