Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-6467

Performance issues in order list

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • None
    • Misc
    • None
    • Version: 3.x
      PHP Version:
      Webserver:
      Database:

    Description

      The order list has a couple of possible performance issues, they are as follows:

      1. Calculation of total ex. vat and total inc. vat involves doing lots of calculation for each order item. The reason is that this information is not stored in the order table. The same thing is probably done for each order item.
      2. Temporary and active orders are stored in the same table (differentiated by is_temporary). This causes each SQL to have the is_temporary=0|1, which in turn causes the sorting to not use an index (the sorting index is also missing).
      Splitting the data into two separate tables might help out here.
      Note: It makes sense to wait for 4.0 to do this.

      Attachments

        Activity

          People

            unknown unknown
            amos amos
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: