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

optimization: query used to store session data

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • 4.1.4, 4.2.0, 4.3.0, 4.4.0alpha4
    • Database related
    • None

    Description

      Current code to store session data in the db selects first current session, then decides to either update or insert.
      This is
      . not atomic
      . not very efficient

      Since we hope that a session is used more than once (avg. pages viewed per user on a site might be 5), it makes sense to do the reverse:
      . update first
      . look at number of rows updated
      . if zero, do insert

      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: