Announcement

Collapse
No announcement yet.

I did a stnadard PDF Report using SC ----> really very slow to produce the PDF

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • I did a stnadard PDF Report using SC ----> really very slow to produce the PDF

    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

    Video https://www.youtube.com/watch?v=NhnxO8lPSww

  • #2
    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?

    Selección_010.png

    This report with lookups, subquery, and so on... (sorry for pixelation) generated under 1 second.
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      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

      Comment


      • #4
        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?

        Comment


        • #5
          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.
          Attached Files
          Last edited by giovannino; 08-09-2015, 07:59 AM.

          Comment


          • #6
            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..
            Attached Files
            Last edited by giovannino; 08-09-2015, 08:15 AM.

            Comment

            Working...
            X