#688 SQL prepared statements not always re-used

Reporter MattJ
Owner MattJ
Created
Updated
Stars ★★ (2)  
Tags
  • Milestone-0.10
  • Priority-High
  • Type-Defect
  • Status-Accepted
  1. MattJ on

    ** This report needs more confirmation through a proper test setup. ** Prosody can create more prepared statements than strictly necessary for some kinds of queries, which can lead to unnecessary resource consumption (i.e. garbage collecting idle prepared statements that could be reused). 0.10 has improved a number of SQL-related things, and I feel strongly that this fix should also go into the release, or at least some testing to assess the real-world impact.

  2. MattJ on

    Changes
    • owner MattJ
    • tags Priority-High
  3. MattJ on

    Changes
    • tags Milestone-0.10
  4. Zash on

    Changes
    • tags Status-Accepted

New comment