On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • So, I have a high volume modx site on a cluster of 4 servers, trying to make sure we are at maximum efficiency. I ask, only because I never see a connection close with the xPDO queries, does the xPDO constructor automatically close/clean these connections for me?

    I am simply trying to avoid sleeping mySQL connections where the php is holding the connection open for no reason while it is processing data.

    ideas?

    • W. Shawn Wilkerson Reply #2, 1 year, 3 months ago
      Quote from: dylanwood at May 01, 2018, 01:48 PM
      So, I have a high volume modx site on a cluster of 4 servers, trying to make sure we are at maximum efficiency. I ask, only because I never see a connection close with the xPDO queries, does the xPDO constructor automatically close/clean these connections for me?

      I am simply trying to avoid sleeping mySQL connections where the php is holding the connection open for no reason while it is processing data.

      ideas?

      xPDO handles all of the connection details and implementation. You can think of it as a persistent connection - the same one MODX is using to display the site. xPDO has a tiny footprint. If your tables are designed efficiently, you should be fine.
      Read more here: http://xpdo.org/about/
        Get your copy of MODX Revolution Building the Web Your Way http://www.sanitypress.com/books/modx-revolution-building-the-web-your-way.html

        Check out my MODX || xPDO resources here: http://www.shawnwilkerson.com