Hello,
I did a report and on my sample it has an header and 3 rows… in total.
It takes about more than one minute to be generate.
Okey… I know that it’s not good module but I’m trying to use it the same.
Is there a way to understand why it’s so slow ?? Is there a kind of log where to understand what it does ??
Thanks
There are a lot of variables involved on this.
How complex is SQL query? What do you do in code? I see you are under hoo.st host, where are hoo.st servers?
This report with lookups, subquery, and so on… (sorry for pixelation) generated under 1 second.
I think it’s a very normal report about a Customer Order . More or less similar to yours.
Expecially when you launch it the very first time is really slow . Does it make sense ?? Could be server that not has some specific features or libraries ?
I don’t think so…
SELECT
orders.OrderID,
orders.CustomerID,
orders.SalesmanID,
orders.EmployeeID,
orders.OrderDate,
orders.RequiredDate,
orders.Expenses,
orders.StatusID,
orders.Id_Ord,
orders.Note_Header,
orders_details.Order_row_ID,
orders_details.OrderID,
orders_details.CustomerID,
orders_details.SalesmanID,
orders_details.OrderDate,
orders_details.ProductID,
orders_details.UnitPrice,
orders_details.CurrencyID,
orders_details.Quantity,
orders_details.Discount,
customers.CompanyName,
customers.Address,
customers.City,
customers.Region,
customers.PostalCode,
customers.Country,
customers.VatCode,
customers.CodFisc,
products.ProductName,
products.Um,
products.Codiva,
vatcode.Iva_perc
FROM
orders LEFT OUTER JOIN orders_details ON orders.OrderID = orders_details.OrderID
LEFT OUTER JOIN customers ON orders.CustomerID = customers.CustomerID
LEFT OUTER JOIN products ON orders_details.ProductID = products.ProductID
LEFT OUTER JOIN vatcode ON products.Codiva = vatcode.Codiva
WHERE orders.OrderID = [glo_OrderID]
ORDER BY orders_details.OrderID, orders_details.Order_row_ID
Just an idea, have no performance issues as you describe, but also do not have four joins in such a SQL-request.
Have you tried to put that into a view and show the view in your report?
Hello,
I did the same query from within in local WAMP and on remote server and it takes less than a second to give me the result. So I dont think that query has particular problems.
Also all the Join point to indexed table on the same field (PRIMARY).
The hoo.st server probably is in USA or in Brazil … I don’t know but I got the same poor result also in local using WAMP so I think there is something on SC Pdf Report that makes the problem.
The only particular thing that I did on setting is to save it on “Server” (see image).
To be esclude also this one I just did a test using “Browser” destination but still… time is so long.
Another information is that the background image is 1,22 MB . To have a sufficient quality I need a certain resolution . Now the background is a png.
OKEY… The IMAGE is the BIG PROBLEM.
I just tried to run the report without image and it took 1 second !!!
What can I do to use a backgrond without having performance problems ??
Now I’ve reduced the quality to 200 pixel but still not a … rocket.
But for sure much more better than before…
