We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
  • 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?

    • 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