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

optimize amount of sql queries ...

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Low Low
    • None
    • None
    • Misc
    • None

    • Version: 3.4alpha1
      PHP Version:
      Webserver:
      Database:

    Description

      Hi,

      I've analyzed the queries which were done by ez3. Plz also have a look at
      http://ez.no/community/forum/developer/performance_mysql_add_index

      I've noticed that several select queries are done for multiple times (if the cache is empty). Some queries were made up to 10 times.

      So my statistic says:
      total select queries: 220 - 350
      unique select queries: 100 - 200

      Yes, I know, you can't prevent "double queries" completly.
      But I think there is another chance to optimize ez3.

      Kind regards,
      Emil.

      Attachments

        Activity

          People

            unknown unknown
            emil.webber emil.webber
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: