Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-56132

Investigate potential usage of MYSQLI_STORE_RESULT_COPY_DATA mode in get_recordset_sql()


    • Icon: Task Task
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 3.1.2
    • Database SQL/XMLDB
    • None

      In the issue MDL-55987 it was confirmed that the current MYSQLI_STORE_RESULT mode of mysqli query can really lead to memory issues as the inline comments predict.

      Recent versions of the mysql driver (available with mysqlnd only, since PHP 5.6.0) offer new mode MYSQLI_STORE_RESULT_COPY_DATA that does not seem to be fully documented yet, but it expresses better behaviour in terms of memory management (with the trade off of the perceived performance but we do not have any stats figures at this moment).

      See the whole story in MDL-55987 comments.

            Unassigned Unassigned
            mudrd8mz David Mudrák (@mudrd8mz)
            2 Vote for this issue
            4 Start watching this issue


                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.