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

use more bound parameters for executing queries on the session table

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Obsolete
    • Icon: Medium Medium
    • None
    • 3.10.1, 3.9.5, 4.0.1
    • Database related
    • None

    Description

      The current code uses in ezsession.php uses binding of params only in the function eZSessionWrite().

      Since this table is quite hammered when web traffic scales up, it would be a good idea to add support for bind params for all the other queries that are excuted by session management functions.

      This means

      • shorter query execution times, as the query does not have to be parsed every time
      • more sharing of cursors within the db, which is good for scalability

      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: