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

remove all unnecessary usages of "select *"

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • 4.0.6, 4.1.3
    • Database related
    • None

    Description

      There are quite a few places where select * is used where a select columnX could be.

      This is bad because

      • extra data is brought from db to php which is not used
      • if selected col is part of an index, no table scan can be done at all

      example offender: ezkeyword.php, line 311

      feel free to put in comments all other such abuses

      Attachments

        Activity

          People

            unknown unknown
            72f8acac-185f-4a54-9470-a7473f50daab@accounts.ibexa.co Gaetano Giunta
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: